CODEWITHSUNDEEP
excel-formulaexcel-2007sumifs
user3729199
user3729199

Reputation: 85

Reffering value from other cells in SUMIFS function

I need to use SUMIFS function in Excel 2007, currently my formula looks like this: =SUMIFS(D:D,B:B,"=string",c:c,"=E")

Now the value of string is placed inside cell A3 of sheet1. Is there any way through which i can refer that value in SUMIFS formula like sheet1!$A$3

I try following code but it didn't work:

=SUMIFS(D:D,B:B,"=sheet1!$A$3",c:c,"=E")

Upvotes: 0

Views: 65

Answers (1)

Robert J.
Robert J.

Reputation: 2701

why don't you directly reference that cell without quotes? such as:

=SUMIFS(D:D,B:B,sheet1!$A$3,c:c,"=E")

Upvotes: 2

Related Questions