P
Phil Fuller \(from Sydney Australia\)
Dear Brad H.
One solution I thought of is this.
1. Make your source functions produce a zero instead of a
blank.
2. the zeros that appear in your current worksheet will
then be able to be counted by the COUNT()function.
3. Using say a combination of the COUNTA() AND COUNT()
functions will give you the answer you want.
4. To count all the names the function would be:
COUNTA()-COUNT().
the COUNTA will count all the cells with formulas in
the range and the COUNT fn will count only the zeros.
Voila, the net result will be the names only
Let me know if this works, please (I love feedback)
If not I will think of something else.
Regards
Phil Fuller
One solution I thought of is this.
1. Make your source functions produce a zero instead of a
blank.
2. the zeros that appear in your current worksheet will
then be able to be counted by the COUNT()function.
3. Using say a combination of the COUNTA() AND COUNT()
functions will give you the answer you want.
4. To count all the names the function would be:
COUNTA()-COUNT().
the COUNTA will count all the cells with formulas in
the range and the COUNT fn will count only the zeros.
Voila, the net result will be the names only
Let me know if this works, please (I love feedback)
If not I will think of something else.
Regards
Phil Fuller