[/I]Thanks, but I don't think it quite works.
There is a little adjustment in your worksheet.
The formula goes as follows:
{=SUM((Q1_Data=B13)*SUBTOTAL(3,OFFSET(Q1_Data,ROW(Q1_Data)-2,0,1,1)))}
However, when it gets to cell B14 which is "Holiday" the formula changes to this:
{=SUM((Q1_Data=B14)*SUBTOTAL(3,OFFSET(Q1_Data,ROW(Q1_Data)-2,0,1,1)))*2}
This means that when I apply the filter, deselecting employee 3 which has all holiday selected, there is still data being read. This is the same trend as the "TBC" category.
EDIT: Oh I see it is because I have "Holiday" for the green section and for the drop down box. So it is counting it twice.
Bookmarks