How Do I Count This LIst?

S

SFCSG

Hi, I have a spread sheet divided by date. There is data on Mon,
Tues., Wed, etc. In the example below I want to be able to count the
number of items under Mon. The answer would be 4. Under Tuesday the
answer is also four. Under Wed. the answer is three. How do I do
that?

Thanks, Steve.


Mon. 4
3
2
5

Tue 6
8
3
4

Wed 2
1
7
 
C

CLR

Check out the Data > Sub Totals feature.........just follow the menus and if
you have trouble, post back with the specifics......

Vaya con Dios,
Chuck, CABGx3
 
J

JMay

Also you can enter a formula for each Day
In Cell C1 (for Monday) =count(B1:B4);
In Cell C5 for Tuesday =count(B6:B9);
etc..
Or get fancier by using Dynamic Range Names -- Mon, Tues, Wed
and entering in Cell C1 = count(Mon);
In Cell C5 = count(Tues)
HTH
 
Top