COUNTIF within DATE RANGE - with multiple lookups

[JM45T3R5]

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!!!

[JM45T3R5]

Sorry, I appear to have posted this in the wrong forum (macros instead of formulas)

[davsth]

Your problem is the breach column is several columns to the right of where you match the name

=SUMPRODUCT(--(DATA!$C$8:$C$314>=Summaries!$F$9),--(DATA!$C$8:$C$314<=Summaries!$F$8),--(INDEX(DATA!$I$8:$CO$314,,MATCH(Summaries!$C15,DATA!$D$2:$CO$2,0))=1))

Seems to work to match with the 1s

[AliGW]

This thread has been moved to the correct section.