multiplying rows and passing formula throughout the col range
Is this confusing?
My formula: sum(C6*D6) to multiply price (C) vs usage (D).
I need to continue multiplying like this to get a final total
to get the amount spent for last year. my example:
R Col C D
6 .47 3400
8 .54 1800
9 1.78 300
|