Count

[CWH]

I am using Excel 2003.

I have the following in a worksheet
TEACHING LUNCH ASC HC ASC
01/Aug/10 Sunday 0.00 0.00 0.00 0.00 0.00
02/Aug/10 Monday HC
03/Aug/10 Tuesday HC
04/Aug/10 Wednesday HC
05/Aug/10 Thursday HC
06/Aug/10 Friday HC
07/Aug/10 Saturday 0.00 0.00 0.00 0.00 0.00
08/Aug/10 Sunday 0.00 0.00 0.00 0.00 0.00
09/Aug/10 Monday HC
10/Aug/10 Tuesday HC
11/Aug/10 Wednesday HC
12/Aug/10 Thursday HC
13/Aug/10 Friday HC
14/Aug/10 Saturday 0.00 0.00 0.00 0.00 0.00
15/Aug/10 Sunday 0.00 0.00 0.00 0.00 0.00
16/Aug/10 Monday HC
17/Aug/10 Tuesday HC
18/Aug/10 Wednesday HC

Is there a function/formulae that would count the number of days, Mon, Tue
etc per column headings so that I would get tis result

Monday 35 33 14 33
Tuesday 37 37 36 14 36
Wednesday 38 38 37 14 37
Thursday 37 37 36 14 37
Friday 35 36 33 16 33

Total 147 183 175 72 176

 

[Eduardo]

Hi,
I assume your information is in Sheet 1 and the summary you are looking for
in Sheet2. In sheet 2 days of the week are in column A and the headers of the
other columns match Sheet 1, so in cell B2 (correspond to Monday and
Teaching) enter

=SUMPRODUCT((Sheet1!B$1:B$1000<>"")*(Sheet1!A$1:A$1000=C3))

copy formula to your right and down

Change range to fit your needs



Copy