Column has entires that are both numerical and "#N/A". The SUM formula at the bottom of the column will not total the numeric entries because of the #N/A cells. Is there a way to total all the cells that have a numeric entry only? The cells will change from #N/A to a number as entries are made in other columns.
If your only errors will be: #N/A
try something like this:
edited to add this:
Please Login or Register to view this content.
Alternatively, depending on your data, this might work:
Is that something you can work with?Please Login or Register to view this content.
Last edited by Ron Coderre; 09-29-2009 at 12:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks