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

One way:

=SUMPRODUCT(--('Data'!C2:C450="ACompany"),--('Data'!G2:G450<""))


In article ,
SS wrote:

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

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

=SUMPRODUCT((Data!C2:C450="ACompany")*(Data!G2:G45 00))

For between dates.

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


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522283

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

"SteveG" wrote:


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

=SUMPRODUCT((Data!C2:C450="ACompany")*(Data!G2:G45 00))

For between dates.

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


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522283