COUNTIF or SUMPRODUCT?

S

Scott

First of all, I would like to say I have found a lot of questions & answers
that have become useful to me in my day to day excel experience. Thanks to
all the posters and the intelligent folks that have the answers! My question
is... I have 2 columns of data, column A A1:A100 =RC44, column B (need to be
less < than 74) count as 1
EXAMPLE:
Column A Column B
RC44 60
RC44 77
RC52 14
RC60 58
RC44 72

If coumn A = RC44 & column B is less than 74 should =1 (or example above is=
2)
Can anyone provide any help?
 
D

Dave Peterson

=sumproduct(--(a1:a100="rc44"),--(b1:b100<74))

Adjust the range, but you can't use the whole column.
 
Top