Hi
I have a spreadsheet laid out with value, category, value, category, etc, across multiple columns on a spreadsheet. What I need to do is add together all the values in the columns (A,C,E,G, etc)based on the category in the column to the right of it (B,D,F, H, etc). So I'd end up with a total for all the "Banana" category, for example.
I can make it work with a really long, nested collection of IF statements, but is there a more elegant way of doing this?
Before the suggestion...I unfortunately can't change the base data.
Thanks in advance for any responses.
I have a spreadsheet laid out with value, category, value, category, etc, across multiple columns on a spreadsheet. What I need to do is add together all the values in the columns (A,C,E,G, etc)based on the category in the column to the right of it (B,D,F, H, etc). So I'd end up with a total for all the "Banana" category, for example.
I can make it work with a really long, nested collection of IF statements, but is there a more elegant way of doing this?
Before the suggestion...I unfortunately can't change the base data.
Thanks in advance for any responses.
