Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to get a count based on three columns of data. In column A I have a
department code, in column B I have plan IDs, and in column C I have a flag that indicates if this is a financial adjustment. I want to count all the plan IDs by department code where it is NOT a financial adjustment(or conversely, where it says "Current"). A B C 004 Plan1 Adj 004 Plan1 Current After reading many of the posts on this forum, I've been trying to get SUMPRODUCT to work. This is what I've written so far: =SUMPRODUCT(--(A$13:A$15000="004"),--(B$13:B$15000="PLAN1"),--(C$13:C$15000="Current")) I should get a count of 10, but it returns 0 not matter how I tweak it. What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNT WITH MULTIPLE CRITERIA | Excel Worksheet Functions | |||
Count Multiple Criteria | Excel Worksheet Functions | |||
COUNT or SUM with multiple criteria | Excel Worksheet Functions | |||
Multiple Count Criteria | Excel Worksheet Functions | |||
I need to count while using multiple criteria | Excel Worksheet Functions |