| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Unique Values Given Criteria | Excel Worksheet Functions | |||
| Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
| Counting Values | Excel Discussion (Misc queries) | |||
| Counting values within a Date Range | Excel Discussion (Misc queries) | |||
| Identifying exact values in alternate rows | Excel Worksheet Functions | |||
Linear Mode
