Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif and hidden rows.
Hello,
Can someone help alter this formula? At the moment the core part of it counts the cells which do not contain the value NA The trouble is the COUNTIF function counts the hidden cells as well. Any suggestions (I'm quite new to excel...) =COUNTIF(Sheet1!F14:F2126,"<NA") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif for only visible rows when combined with autofilter - possible? | Excel Discussion (Misc queries) | |||
How do you ignore hidden rows in a countif() function | Excel Worksheet Functions | |||
COUNTIF help | Excel Worksheet Functions | |||
how to ignore hidden cells with a countif | Excel Worksheet Functions | |||
How do I use countif across non-adjacent cells? | Excel Worksheet Functions |