multiplying rows and passing formula throughout the col range

[Sistereinstein]

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

 

[T. Valko]

In other words, you want a single formula to calculate the grand total?

Try this:

=SUMPRODUCT(C6:C9,D69)

 

[Sistereinstein]

I think we are on the right track. For whatever reason, I keep on getting
$2570.00 as a total, which is the total for the first two, and the correct
total should be $3104.00. I checked the formats and the $ amt is set to
number w/ 2 decimal pts and the usage is number w/0 decimal pts, all down the
rows.

I also moved the range past those cells to see if the amount changed, and it
didn't. Is this a bug? Doesn't seems it should be...

 

[Peo Sjoblom]

Bug? You must have invisible characters (spaces/html characters etc) in one
or both of the last 2 cells making it text.
It doesn't matter if you check the formats, if I format a cell as a currency
and type in abc it will not change the format but it will be text even if
the format says currency. Select the cells and type in 1.78 and 300 manually
and it should work.

--


Regards,


Peo Sjoblom