SOLVED

Sumif with Relative reference

Copper Contributor

Hi,

 

I want to sum a column and sum only cells that the cell in the next column is equal to.

Hadas365_0-1644298009368.png

it shold give in this 

 

 

 

 

4 Replies

@Hadas365 You didn't finish the question, but I suspect you need something like this:

Screenshot 2022-02-08 at 06.49.04.png

SUMPRODUCT will work in all Excel versions. FILTER works in recent Excel versions only.

I have attached a file containing the examples in the picture.

HI,
thanks. the filter works great.
but if i want to add additional term?
best response confirmed by Hadas365 (Copper Contributor)
Solution

@Hadas365 More about using multiple criteria with FILTER in the attached link.

https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759 

it works!
thanks!
1 best response

Accepted Solutions
best response confirmed by Hadas365 (Copper Contributor)