Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|