Excell 2007 - Using Functions

[SkinnyT]

Hello All,
Thanks in advance to all who can help here. I have an excel spreadsheet listing several users within our organization. I'm trying to use a formula that will add up all the users so I can keep a running total. Excel seems to only want to recognize numbers in order to count and get a total number but the cells are text entries. How do I go about using a formula to add up these users for a grand total? Thanks again!

Sr. System Support Analyst
Washington, DC

 

[SkipVought]

Hi,

COUNTA function?

Data > Subtotals?

Data > PivotTable?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnthonyHo2008]

Obviously, the "Counta" function caters for all the number as well as text characters (non-blank cells). You may also want to take a look into the "Dcounta", "Dsum" or "SumIf" functions, these allow you to specific certain criteria for the calculation.

Beside that as the previous message said, you may try the "Subtotals" feature, but remember to do some sorting first.

Cheers.