Converting Non-Number Cell Value to Number For Sum
I have an Excel sheet with a list of names in different categories. I'd like to select these sections of names (eg. A3:A17, A25:A30, etc) and at the bottom, have a count of how many names there. Is there a way to write, "If there is any value in a cell, count it as one, then add them up"? I have been counting the names and just writing the number at the end, but the value keeps changing and I figured Excel is probably more efficient at counting than me.. thanks!!!
Last edited by GSomething; 01-16-2012 at 08:27 PM.
Use COUNTA
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
COUNTA seems to be working for a single range, but not multiple ranges. Is there something I need to amend to the formula to make it add values?
=COUNTA(C3:C20) produces a positive count result.
=COUNTA(C3:C20+C25:C30) produces a count result of 1.
=counta(c3:c20)+counta(c25:c30)
Ben Van Johnson
Done and done. Thank you both!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks