Excel Formula need help

C

coan.jim

I am trying to get a count of one column based on criteria in another
column

Column B always equals either 'true' or 'false'. I need to find a
count of 'true". (True being the test was taken)

so If A:A= 'test#3', then count # of 'trues' (in column B:B), related
to the same test name in A:A

Please help and thanks
 
B

Bob Phillips

=SUMPRODUCT(--(A2:A200="test3"),--(B2:b200=TRUE))

SUMPRODUCT won't work with whole columns.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top