If

[Guest]

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

 

[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

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(A1:A1000="3dsu"),--(H1:H1000="fall history"))

for an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

 

[Guest]

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

 

[Guest]

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