ExcelBanter - Need Help with Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need Help with Formula (https://www.excelbanter.com/excel-discussion-misc-queries/1359-need-help-formula.html)

Kimberly Bassininsky

Need Help with Formula

Here is what I am trying to do:

(c64*c66) + (d64*d66) + (e64*e66) ........(z64*z66)

Is there a way to do this without entering the formula with each cell
reference?

Thanks.

Kim

Frank Kabel

Hi
=SUMPRODUCT(C64:Z64,C66:Z66)

--
Regards
Frank Kabel
Frankfurt, Germany

"Kimberly Bassininsky" schrieb im
Newsbeitrag ...
Here is what I am trying to do:

(c64*c66) + (d64*d66) + (e64*e66) ........(z64*z66)

Is there a way to do this without entering the formula with each cell
reference?

Thanks.

Kim

All times are GMT +1. The time now is 12:26 PM.