SUMIFS Formula

[razaas]

Hello everyone,


I have a question, is it possible to set two sum ranges from two different worksheets in sumifs formula? Any help is highly appreciated. Thanks in advance.

 

[oldchippy]

Hi,


Take a look here at Harlan Grove's response to this type of question


http://www.sqldrill.com/excel/worksheet-functions/105852-sumif-multiple-worksheets.html

 

[razaas]

oldchippy,

Thanks for response, I think my question is not properly explained, what I want to know if sumifs formula allows to set two sum ranges or not, it does not matter the required sum ranges are in the same worksheet or the different. Hope this make sense now, thanks.

 

[Hui]

Razaas

If in A1:C4 you have this

[pre]

a	1	11
b	2	22
c	3	33
b	2	44

[/pre]
Then

=+SUMPRODUCT(1*(A1:A4="b"),(B1:B4)+(C1:C4))

will sum up column B + C when the criteria in Column A is met

 

[razaas]

Hui,

Thanks a lot, it works well, as usual your solutions are great. Thanks again.