| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count rows with content in some columns
Hi all,
I want to count the number of rows (1 to 1000) that have content in columns AK to AO. I want to do it with a formula (so no helper column or VBA). I guess that I could use something like --(MMULT(--(AK1:AO1000<""),{1;1;1;1;1})0) but I can't get it working. Your help will be appreciated. Jack Sons The Netherlands |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Columns, Return Content | Excel Worksheet Functions | |||
| Count rows with criteria from two columns? | Excel Worksheet Functions | |||
| Count if in multiple rows / columns | Excel Discussion (Misc queries) | |||
| Count entries in columns and rows | Excel Worksheet Functions | |||
| Reduce columns and rows count? | Excel Worksheet Functions | |||
Threaded Mode
