I have a column of values (expenses, to be exact). The next column may have any of several flags, represented as letters. So it would look something like this:
I want the sum of values where the next column contains a given flag. I can do this by creating an intermediate column that contains either 0 or the flagged value (using an IF command), then summing that column.
Is there a way to do this without an intermediate column?