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 |
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 |
All times are GMT +1. The time now is 08:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com