Forum Discussion
Solved
Sum of multiple rows using VLOOKUP
We are trying to use VLOOKUP in order to retrieve the multiple values. We have a value that we are looking for and we want to have the sum from all the cells that this value is related to. For exampl...
You can use something like
=SUMIFS(range_with_numbers, range_with_colors, "Green", other_range, "<>Apple")
if you only want to sum numbers where the color is green and another column does not contain Apple.
Hello,
Thank you. What do I use if I want to exclude som of the cells that are included if I use "SUMIF"?
Thank you. What do I use if I want to exclude som of the cells that are included if I use "SUMIF"?
- You can use SUMIFS() if you have multiple criteria and you can also use FILTER()
=SUMIFS(range-to-sum, range-with-colors, "Green", range-with-other-info, other-criteria, ...)
=SUM( FILTER(range-to-sum, (range-with-colors = "Green")*(range-with-other-info = other-criteria)*... , 0) )- Okay thank you.
Is there any other option if I want to just exclude one criteria? or do I have to enter all the criteria that I want to include?You can use something like
=SUMIFS(range_with_numbers, range_with_colors, "Green", other_range, "<>Apple")
if you only want to sum numbers where the color is green and another column does not contain Apple.
