Help Counting

[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

[JE McGimpsey]

One way:

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


In article <[email protected]>,
SS <[email protected]> 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

[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

[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

"SteveG" wrote:

>
> 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
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=522283
>
>