If

D

d richardson

I am rying to count if two colums equal a certain values
i.e. if cells in column a = 3dsu and cells in column h=fall history then
count it
 
B

Bob Umlas

=IF(AND(A1="3dsu",H1="fall history"),value if true,value if false)
To COUNT these:
=SUMPRODUCT((A1:A100="3dsu")*(H1:H100="fall history"))

Bob Umlas
Excel MVP
 
D

D richardson

I get a #num! error
this is my formula:
=SUMPRODUCT((jan!C:C="*3dsu*")*(H121:H127="*history of falling*"))
 
B

bj

Sumproduct needs equal ranges, try
=SUMPRODUCT((jan!C121:C127="*3dsu*")*(H121:H127="*history of falling*"))
 
Top