Some assistance is needed using SUMIFS

Hi,

I have data that I would like to populate from the source spreadsheet into the summary spreadsheets(C2348-001 and C2348-002) using SUMIFS. However, on my attempt to do so, I'm getting the update value save as prompt.

What I'm looking to do is for each code and description, I would like to populate the value for each of the associated months.
I tried the below formula, but aforementioned I get the update value save as prompt

Formula:=SUMIFS(Source!C:C,Member!$A:$A,$A$1)

Thanks in advance for your help

Originally Posted by Bryceston

Formula:=SUMIFS(Source!C:C,Member!$A:$A,$A$1)

There is no sheet named Member in the book you posted.

Is this what you're after
=SUMIFS(Source!C:C,Source!$A:$A,$A$1,Source!$B:$B,$A2)

Thank you both, your feedback was very helpful.

You're welcome.