| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New formula: = does not disappear | Excel Discussion (Misc queries) | |||
| Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
| Preserve Excel formula entry | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| hyperlink formula | Excel Discussion (Misc queries) | |||
Linear Mode
