count based on two fields - need quickly
 

HELLO,
I am trying to get a count based on two fields.
I want to return the count based on if cells in col B = X and cells in col
A = Y
I have tried "=COUNTIF(H23:H999,A1) + COUNTIF
(B23:B999,A8)" but it is giving me the count of the result plus the count
of the second result.
Can anyone help.

=SUMPRODUCT(--($H$23:$H$999=A1),--($B$23:$B$999=A8))

JO Wrote:
HELLO,
I am trying to get a count based on two fields.
I want to return the count based on if cells in col B = X and cells in
col
A = Y
I have tried "=COUNTIF(H23:H999,A1) + COUNTIF
(B23:B999,A8)" but it is giving me the count of the result plus the
count
of the second result.
Can anyone help.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274346