try
=SUMPRODUCT(--(G2:G6={5710,5694}),--(H2:H6=6))


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:a5b290940805a@uwe...
Hi

Struggling to get this to work, despite looking at the treads. Using excel
2003.
trying to count how many times 5710 in col G has "6" in Col H

col-G col-H
5710 --- 7
5710 ----6
5694 ----6
5678----3
5710 ---6

=SUMPRODUCT(--(G2:G6=5710),--(H2:H6=6))

Would like to add 5694 as well as 5710, is this possible and does if have
to
be on the same sheet?
thanks in advance
brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201003/1