Hi, all.
I have a spreadsheet that lists every Friday, Saturday, and Sunday for each month of 2015 in column B. The cells are date-formatted and display like this
Fri 02 Jan 15
For each entry in column B, column C can contain one of four character entries, 'F', 'P', 'MM', or 'PF', or it can be empty.
At the foot of each month I need to to show the total number of F's (see note below), P's and PF's for Fridays, Saturdays, and Sundays, like this
F P PF
Fri 2 2 0
Sat 1 3 1
Sun 2 0 0
Note: The 'F' column needs to show the totals for 'F' and 'MM' values combined.
Can anyone recommend a formula that will do this for me at all?
Thank you,
Goth
Bookmarks