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.
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?
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.
- Okay thank you.
This worked for what I needed.