Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count
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 "CWH" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |