Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF
I am trying to count values based on 3 sets of criteria. In this case, I am
trying to count the number of times the value in column A exceeds 1,000 but only when column B = Central Region and column C = Group A. Any suggestions??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF
if you have Excel 2007 then put this in the cell (except in cols A to C) you
want the result to be; =SUMPRODUCT(--((A:A)1000),--((B:B)="Central Region"),--((C:C)="Group A")) and press enter while holding down ctrl and shift keys "readystate" wrote: I am trying to count values based on 3 sets of criteria. In this case, I am trying to count the number of times the value in column A exceeds 1,000 but only when column B = Central Region and column C = Group A. Any suggestions??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |