In Excel, I'm attempting to use COUNTIFS to count the number of values based on several conditions and numerous columns. This is an illustration of what I'm attempting:

```ColumnA        ColumnB
16             12.4
-              2
15             -
8              -
-              25
-              12
20             23
15             19
12.5           10
```

When ColumnA exceeds 12.5 and when each value in ColumnB exceeds the equivalent value in the same row when compared to ColumnA, those are the conditions I'm looking to look for. Because only two rows in ColumnA have a value more than 12.5 and where the matching value in ColumnB is greater than the value in ColumnA, the count in the sample data shown above should be 2.

I've tried this but it's giving me a 0 count,

`=COUNTIFS(A1:A9, ">12.5", B1:B9, ">A1:A9")`
Apr 4, 2023 in Others 431 views

## 1 answer to this question.

Use  SUMPRODUCT and double unay operators:

`=SUMPRODUCT(--(A1:A9>12.5)*--(B1:B9>A1:A9)*--(ISNUMBER(B1:B9)))`
• 38,010 points

## How to Freeze Top Row and Apply Filter in Excel Automation with C#

Try this: // Fix first row workSheet.Activate(); workSheet.Application.ActiveWindow.SplitRow = 1; workSheet.Application.ActiveWindow.FreezePanes ...READ MORE

## How to find out how many rows and columns to read from an Excel file with PHPExcel?

Solution: \$file_name = htmlentities(\$_POST['file_name']); \$sheet_name = htmlentities(\$_POST['sheet_name']); \$number_of_columns = htmlentities(\$_POST['number_of_columns']); \$number_of_rows ...READ MORE

## How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

## Excel Formula Query on Summing Annual Leave Days and Half Days

Try Something like =SUM(COUNTIF(\$A\$1:\$A\$8,"A"),COUNTIF(\$A\$1:\$A\$8,"HA")/2) - total count ...READ MORE

## Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

## How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE