Excel sum from column based on another column
- by jsmars
I have two columns.
The values in the first one are either blank or have a 1.
The values in the second one is a number.
I also have a variable field.
At the bottom of each column, I'd like to have a "total" field, which checks if there is a value (of 1) in the first column, and if there is, adds this up from the value of the second column (on the…