=SUMPRODUCT(--(A1:A100="RC44"),--(B1:B100<74))

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"Scott" wrote in message
...
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?