Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTING FORMULA
I'm sure this is easy, but not for me.
A B MISSING JOE MISSING JOE ENTERED LINDA MISSING SUE NEED A FORMULA TO COUNT IF A:A = MISSING AND B:B=JOE RESULT WOULD BE 2 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTING FORMULA
=sumproduct(--(a1:a10="missing"),--(b1:b10="joe"))
Adjust the ranges to match--but you can't use whole columns (except in xl2007). =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail he http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html TMF in MN wrote: I'm sure this is easy, but not for me. A B MISSING JOE MISSING JOE ENTERED LINDA MISSING SUE NEED A FORMULA TO COUNT IF A:A = MISSING AND B:B=JOE RESULT WOULD BE 2 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting formula | Excel Worksheet Functions | |||
formula for counting | Excel Worksheet Functions | |||
Counting Formula | Excel Worksheet Functions | |||
formula on counting | Excel Discussion (Misc queries) | |||
Counting Formula | Excel Discussion (Misc queries) |