Hi folks
I'm trying to get the contents of cells added together based on the month and location that refer to those cells using:
=SUMPRODUCT(TEXT(Weekly_Attend!C3:L3,"mmm")=TEXT(Dashboard!D17,"mmm"),(Weekly_Attend!B4:B7)=Dashboard!C17,Weekly_Attend!C4:L7)
However, it keeps returning a #VALUE error, any ideas please??
Count-by-Month-and-Locationxlsx.xlsx
I've attached a sample workbook so that it can be seen how I'm trying to get it to work.
Any help really appreciated please...
Kind regards
DezB