Help Counting

S

SS

I am trying to have a cell count based on the conditions of two other cells
on a different sheet. Lets say my sheet names are Data and Stats, and I need
a cell in my Stats page to only count cells which are on the Data sheet range
C2:C450 and equal to "ACompany" AND cells which are on the Data sheet range
G2:G450 and not null.

I know this should be easy, but I haven't worked in excel in a long time. A
followup to this question would be the same thing except the cells G2:G450
would be between two specified dates.

Many Thanks
 
S

SteveG

So you are trying to count the number of times that both conditions are
met?

=SUMPRODUCT((Data!C2:C450="ACompany")*(Data!G2:G450>0))

For between dates.

=SUMPRODUCT((Data!C2:C450="ACompany")*(Data!G2:G450>DATE(2006,3,1))*(Data!G2:G450<DATE(2006,3,13)))


HTH

Steve
 
S

SS

Great help guys!
This is the first time I have used this forum and was suprised with the fast
and helpful responses.
Best Regards,
SS
 
Top