| 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 |
|
#2
|
|||
|
|||
|
SUMPRODUCT nor array formulas can handle entire column
references. Rather than using D:D, use something like D1:D2000. HTH Jason Atlanta, GA -----Original Message----- 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 . |
|
#3
|
|||
|
|||
|
Perfect... I thought there was something wierd like that, I just couldn't
remember or find it in the newsgroup. Thanks! "Jason Morin" wrote: SUMPRODUCT nor array formulas can handle entire column references. Rather than using D:D, use something like D1:D2000. HTH Jason Atlanta, GA -----Original Message----- 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 . |
| Reply |
| 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 | |||
Linear Mode
