counting rows depending on 2 selective values
 

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

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