counting rows depending on 2 selective values

[Acid-Sky]

Hi,

well, I have lots of data and need to do some statistics on it. For that I need to count the number of rows "H" where a string value "X" is written but only if these rows also have cell which is NOT empty in column "E"...

the if stuff drives me crazy (especially as i have a spanish version...)

any help appreciated

[Duke Carey]

try

=sumproduct(--(h1:h1000="x"),--(not(isblank(e1:e1000))))

"Acid-Sky" wrote:

>
> Hi,
>
> well, I have lots of data and need to do some statistics on it. For
> that I need to count the number of rows "H" where a string value "X" is
> written but only if these rows also have cell which is NOT empty in
> column "E"...
>
> the if stuff drives me crazy (especially as i have a spanish
> version...)
>
> any help appreciated
>
>
> --
> Acid-Sky
> ------------------------------------------------------------------------
> Acid-Sky's Profile: http://www.excelforum.com/member.php...o&userid=26502
> View this thread: http://www.excelforum.com/showthread...hreadid=401163
>
>