| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating rows
I need help in excel. I want to calculate total sums by multiplying 2 rows
then follow by addition. I have the rough idea how to do but the problem is very complicated because I have 53 column of data. The 1 trying to do is like this $B$1*B3+$C$1*C3+.....+$BZ$1*BZ3. Is there a simpler way of doing? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculating rows
try:
=sumproduct(b1:bz1, b3:bz3) "Jacks89" wrote: I need help in excel. I want to calculate total sums by multiplying 2 rows then follow by addition. I have the rough idea how to do but the problem is very complicated because I have 53 column of data. The 1 trying to do is like this $B$1*B3+$C$1*C3+.....+$BZ$1*BZ3. Is there a simpler way of doing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using sum function,can I avoid calculating hidden rows | Excel Worksheet Functions | |||
| Inserted Rows not re-calculating | Excel Discussion (Misc queries) | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| deleting rows--calculating formulas with each row as it goes? | Excel Discussion (Misc queries) | |||
Linear Mode
