How do you calculate text into numerical answers?

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Facetime Measurement 1
Calculate number of Mondays betweeb 2 dates 6
Countif Function?? 3
How do you calculate workdays if Saturday is a workday? 3
Week count 2
Sumproduct W-t-d 4
calculating hours in one cell 2
SUMIF Help 1

Top