One way:

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

for an explanation of "--" see

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



In article ,
d richardson <d wrote:

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