| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count within a Range Q
Yeah, it's a bit simpler to count a blank range than the populated cells in
a block <bg -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sean" wrote in message ... Thanks Bob a neater take on my one which was =if(=SUM(--((INDEX(A5:A20,MIN(IF(A5:A20<"",ROW(A5:A20)- MIN(ROW(A5:A20))+1))):I*NDEX(A5:A20,MAX(IF(A5:A20< "",ROW(A5:A20)- MIN(ROW(A5:A20))+1))))=""))=15,0,=SUM(-- ((INDEX(A5:A20,MIN(IF(A5:A20<"",ROW(A5:A20)-MIN(ROW(A5:A20))+1))):I* NDEX(A5:A20,MAX(IF(A5:A20<"",ROW(A5:A20)-MIN(ROW(A5:A20))+1))))="")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| VBA help Range Count | Excel Discussion (Misc queries) | |||
| Using a count in a range name | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Threaded Mode
