Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formulas
I am trying to get sum in G9 using G3 x D3 + G5 x D5 + G7 x D7. Can somebody
help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formulas
"Eric" wrote:
I am trying to get sum in G9 using G3 x D3 + G5 x D5 + G7 x D7. One of these options in G9 should do it: 1. Simplest: =SUM(G3*D3,G5*D5,G7*D7) 2. If intervening cells are blank: =SUMPRODUCT(D3:D7,G3:G7) 3. If intervening cells need to be skipped: =SUMPRODUCT(--(MOD(ROW(D3:D7),2)=1)*D3:D7*G3:G7) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formulas
The 3rd option should read simply as:
=SUMPRODUCT((MOD(ROW(D3:D7),2)=1)*D3:D7*G3:G7) (no need for the preceding: "--") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formulas
Well, there is always this way...
=G3*D3+G5*D5+G7*D7 Rick "Eric" wrote in message ... I am trying to get sum in G9 using G3 x D3 + G5 x D5 + G7 x D7. Can somebody help? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formulas
Thanks Max. I actually figured it out just before your reply came through; I
did it with the first option you listed. I have a much harder one I am trying to figure out now. I have figured out the formula to get the sum from 31 sheets on to a summary sheet at the end of the Excel book; EX: =SUM(1:31!J3:J8). However, I now need to know how to do it with an exception. Ex: I need =SUM(1:31!P3:P8) BUT ONLY IF THE FIGURES IN P3:P8 ARE POSITIVE. Then I need, for another cell, =SUM(1:31!P3:P8) BUT ONLY IF FIGURES IN P3:P8 ARE NEGATIVE. "Max" wrote: "Eric" wrote: I am trying to get sum in G9 using G3 x D3 + G5 x D5 + G7 x D7. One of these options in G9 should do it: 1. Simplest: =SUM(G3*D3,G5*D5,G7*D7) 2. If intervening cells are blank: =SUMPRODUCT(D3:D7,G3:G7) 3. If intervening cells need to be skipped: =SUMPRODUCT(--(MOD(ROW(D3:D7),2)=1)*D3:D7*G3:G7) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formulas
Eric,
Suggest you put in a fresh new posting for your new query -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |