countif
 

=AND(COUNTIF(A1:A5,"HM"))*(COUNTIF(B1:B5,"5"))
Trying to calculate the following:
A B
1 HM 5
2 HM 2
3 HM 4
4 HG 5
5 HM 5

Count the number of times "HM" is in column A and "5" is in column B.

Thanks for the help.
Todd


--
play01
------------------------------------------------------------------------
play01's Profile: http://www.excelforum.com/member.php...o&userid=32635
View this thread: http://www.excelforum.com/showthread...hreadid=524432

countif
 

Todd

=SUMPRODUCT((A1:A5="HM")*(B1:B5=5))

Regards

Trevor


"play01" wrote in
message ...

=AND(COUNTIF(A1:A5,"HM"))*(COUNTIF(B1:B5,"5"))
Trying to calculate the following:
A B
1 HM 5
2 HM 2
3 HM 4
4 HG 5
5 HM 5

Count the number of times "HM" is in column A and "5" is in column B.

Thanks for the help.
Todd


--
play01
------------------------------------------------------------------------
play01's Profile:
http://www.excelforum.com/member.php...o&userid=32635
View this thread: http://www.excelforum.com/showthread...hreadid=524432

countif
 

Try this

=SUMPRODUCT(--(A1:A5="HM"),--(B1:B5=5))

If the 5 is text not numeric then use "5" instead


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524432