Feb 07 2022 09:31 PM
Hi,
I want to sum a column and sum only cells that the cell in the next column is equal to.
it shold give in this
Feb 07 2022 09:50 PM
@Hadas365 You didn't finish the question, but I suspect you need something like this:
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.
Feb 07 2022 09:59 PM
Feb 07 2022 10:14 PM
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
Feb 07 2022 10:14 PM
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