If
 

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

=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 richardson" <d wrote in message
...
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

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

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

"Bob Umlas" wrote:

=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 richardson" <d wrote in message
...
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

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

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

"Bob Umlas" wrote:

=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 richardson" <d wrote in message
...
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