Formula Help

[Margs2025]

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 the following -

look up data in sheet 1 cell A1 to Sheet 2 relating to data in column A. The argument being that if what is A1 sheet 1 and sheet 2 column A to return the value that is in Cell J50 if it relates to a specific code in Column B1 in sheet 1 and the same code in Column C in sheet 2

[#2]

@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)

[#3]

@Jan Karel Pieterse thank you so much for your assistance!