Hello friends
I've been trying create a summary table which uses a a formula to count the number of 1s in a particular column, for a particular person, within a date range. It's proved a step too far for my knowledge!
My hope is the formula is able to adjust the count when the dates are changed. I am also trying to link this to the individual name code (column C). E.g. how many were there for Simon in the last month, or last year etc.
I have attached a mock spreadsheet which is as close to the real format as I can get it
It should be clear that I am trying to fill the yellow boxes, with data from the 'DATA' tab - I have already had a stab at the formula, but it doesn't appear to have worked for me.
any help would be greatly appreciated.
thank you!!!
Bookmarks