MS Excel there are numerous calls

**Davismoore** · 05-25-2010, 01:32 PM

In MS Excel, I am annoying to regular calls per day. Each row is
one call, there are numerous calls in one day. What is the correct
method

**JacksonPerez** · 05-25-2010, 01:33 PM

It would depend on the data in the cells that holds the calls - if it's numeric it's more basic than if it's text.

**ThompsonHarris** · 05-25-2010, 01:34 PM

Primary you require the number of calls each day - assuming the cells contain text and they are in the range C2 to C12 you would require the formula =COUNTA (C2:C12). If the cells contain numbers use =COUNT instead of =COUNTA. Replicate that for the ranges that contain each other day's calls and you will have a list of the number of calls made each day.