Counting 7th cells under certain criteria

[sallylongden]

I have a spreadsheet that has the calender year down column D (15:380) and a letter next to each day in column E. I want to create a summary of a years events in D6 for example counting the number of Fridays that were worked so would have a reference letter of I, U, or L. Any help would be greatly appreciated.

[dilipandey]

Hi Sallylongden,


Welcome to the forum.
Would it be possible for you to upload the sample workbook.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Søren Larsen]

E.g. to count # U on fridays, you can use this:

Please Login or Register  to view this content.

EDIT: BTW: Monday=1, Tuesday=2 etc.

[MarvinP]

Hi Sally,

Perhaps the attached example will help with this question.

[sallylongden]

Right, here's hoping this makes sense to people...
Below I have tried to copy a portion of my spreadsheet.
Column A allows the spreadsheet to be told when bank holidays appear.
Column B does not have much in it in the top summary section, but has the month in further down, this is worked out automatically from a column C reference.
Column D has the year reference in the top to enable the dates further down to be worked out, the number of weeks is worked out automatically, and it also has the reference names for what I want my summary to show.
Column E has the reference letters next to associated dates, and at the top section, in teh question marks is where I want it to work out e.g. how many Fridays joe bloggs has worked.

Hope this helps


A B C D E
Year 2012 In shift, no issues = I No Show = NS
Today 28/06/2012
No. Weeks 27
Employee Name joe bloggs
Fridays 0 ?
Saturdays ?
Sundays and B/H's ?
No Show Days 1
Late Days 2
Sick Days 2
Appearance Issues 1

P Month Day Weekdy
January 1 Sun W W
p 2 Mon P P
3 Tue ns
4 Wed l
5 Thu s
6 Fri 1
7 Sat i W
8 Sun W W
9 Mon
10 Tue u
11 Wed s
12 Thu
13 Fri
14 Sat W W
15 Sun W W

[sallylongden]

OK, a little more tampering and I have managed to attach my current spreadsheet, you will see that I have been trying allsorts in the cells E6:F8 in an attempt to get nearer to my desired solution.