Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using COUNTIF with 2 criteria - SUMPRODUCT?
Greetings,
I would like to COUNTIF with 2 criteria and I have read on how to use SUMPRODUCT to accomplish this. However, I am still getting a pretty #NUM! error in the calculation. Here is my formula: =SUMPRODUCT(--('Turnover Details by HR Group'!D:D=A4),--('Turnover Details by HR Group'!B:B=$B$2)) Please help. Thank you, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Countif with dynamic criteria | Excel Worksheet Functions | |||
Sumproduct - multiple criteria in Column A | Excel Worksheet Functions | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions |