Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tweak formula to not count blanks as 0
I need to modify this array-entered formula to not count blanks as zero. The
challenge seems to be that the cobination of INDIRECT() and N() is converting blanks to zero. {=MIN(N(INDIRECT("Rater" & ROW(1:4) & "!G"&$B$3)))} In plain english, the function looks at the same cell (e.g., G7, when cell B3 is set to 7) across 4 worksheets (Rater1 thru Rater4). I don't need to first function to be MIN, it could be a COUNT. I just need it to stop treating blanks as 0. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Blanks | Excel Discussion (Misc queries) | |||
count blanks in pivot table | Excel Worksheet Functions | |||
Count the blanks | Excel Worksheet Functions | |||
Count IF excluding blanks or zeroes | Excel Worksheet Functions | |||
Count blanks cells | New Users to Excel |