I have a spreadsheets with employee names in several different columns....first column is hard keyed with names, additional columns link to the preceding columns so if an employee gets added or deleted the future weeks will reflect the new names. I need a formula to count the employees names in each column excluding the blank rows that have link formulas in them referring to empty positions....the COUNTA formula is still counting the empty positions and the COUNTIF won't work at all for me.
Any ideas??
Last edited by bjohnsonac; 01-24-2011 at 11:46 AM. Reason: SOLVED
A sample might help - it's not clear what the "blanks" are showing (null or 0)
It might be the case that:
will do what you want but that's very much a shot in the dark (obviously change <range> as appropriate)=COUNTIF(<range>,"?*")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Not sure I fully understand, but how about?
=COUNTIF(A1:A10,"?*") which should exclude formula null results. Adjust range to suit.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Thank worked! Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks