How do you calculate text into numerical answers?

T

tyler8

in excel 2003 and I am trying to get a sum of textual data that is the same.
For example If i have monday listed 5 times in the same column amongst the
other days of the week, i want a function that allows me to add the mondays
up and give me the number 5.
 
N

Niek Otten

That's called a count, not a sum.
Look in HELP for the COUNTIF() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| in excel 2003 and I am trying to get a sum of textual data that is the same.
| For example If i have monday listed 5 times in the same column amongst the
| other days of the week, i want a function that allows me to add the mondays
| up and give me the number 5.
 
Top