Forum Discussion
Formula Help
SUMIFS('TENANT DETAIL FY20'!A49:U4068;A2;"oa000";'TENANT DETAIL FY20'!C59:C4068;'TENANT DETAIL FY20'!J49:J4068) I inserted this formula; but it results in a #VALUE result. I basically need to do th...
Margs2025 The first argument must be just the column with the values for the criteria. Also, the size of the range (# of rows) should be the same. Furthermore, you have omitted an argument (the criteria belonging to column C). Finally, you want to set the references to absolute.
Changes in bold:
SUMIFS('TENANT DETAIL FY20'!$A$49:$A$4068;A2;"oa000";'TENANT DETAIL FY20'!$C$49:$C$4068; [MISSING ARGUMENT] ;'TENANT DETAIL FY20'!$J$49:$J$4068)
