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