COUNTIF or SUMPRODUCT?
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?
|