Forum Discussion
Solved
Use COUNTIFS and INDEX/MATCH to pull data from another table
Hi. I have two tables, one with information (Attendance Sheet) and one where I need to pull information into (Info sheet). I have attached screenshots of both tables. I would like to count ho...
=SUMPRODUCT((Attendance_table[[week1]:[week6]]="attended")*(Attendance_table[council]=[@concil])*(Attendance_table[term]=[@term])*(Attendance_table[[#Headers],[week1]:[week6]]=[@week]))
The attached sample file uses SUMPRODUCT and should return the intended result if i correctly understand what you are looking for.
=SUMPRODUCT((Attendance_table[[week1]:[week6]]="attended")*(Attendance_table[council]=[@concil])*(Attendance_table[term]=[@term])*(Attendance_table[[#Headers],[week1]:[week6]]=[@week]))
The attached sample file uses SUMPRODUCT and should return the intended result if i correctly understand what you are looking for.
- Legend, thank you
