appreciate the suggestion. is there a way to do it without making column 4?
for example, I just want the total without making a new column, instead just placing it in the same column at the end as a total.
i have been trying various functions like if, vlookup, and lookup but can't seem to...