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
Bookmarks