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 07:27 PM.
Use COUNTA
Regards, TMS
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
Reply With Quote
Bookmarks