SUM(IF(INDEX(MATCH()))) Confusion to return multiple results and count how many

Hey,

This to me is a very complicated problem and I have found similiar problems solved on forums but nothing yet that translates and works to my issue.

I have attached the table so you can see what I am trying to achieve.

I am trying to record how many times each member has attended in the given range of dates.
Currently Column C gives me how many times they have attended (i.e. ="Attended" or "Yes"), I would like this to only count the results that the dates fall in between the range given in cells C2 & C3.

I will keep adding Columns leftmost of D and so INDIRECT() type references might be needed.

If you need more information then please let me know but I think you should have all the info.

Thanks

Adam

Thanks for all the replies, I found the below formula the best for my use.

=SUM(COUNTIFS($D$2:$M$2,">="&$C$2,$D$2:$M$2,"<="&$C$3,D4:M4,{"Attend*","Yes"}))

I now realise I had been so close with a previous attempt but I don't think I'd have got there in the end so thanks.

Adam

Can anyone explain when you use SUM(COUNTIFS..., instead of just SUM or instead of just COUNTIFS?
Thank you.

Thank you--that's clear!