Hi
I need to be able to calculate the total number of days but only where another cell is equal to 1 and also link this to a specific quarter.
So I have total days generated in cell D9 but I only want to add this to the overall total if F9 = 1
Finally this also needs to be calculated on a specific quarter which is referenced in cell I9
So my summary table is based on quarters and for quarter 1,I only want figures from D9 where F9=1 and I9 also =1
I hope this makes sense.
I think I have attached the file!
Thanks for any help with this.
SSGDSG
Bookmarks