E
Eric
I am trying to get sum in G9 using G3 x D3 + G5 x D5 + G7 x D7. Can somebody
help?
help?
M
Max
Eric said:
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
7,G3:G7)3. If intervening cells need to be skipped:
=SUMPRODUCT(--(MOD(ROW(D3
7),2)=1)*D37*G3:G7)---
M
Max
The 3rd option should read simply as:
=SUMPRODUCT((MOD(ROW(D37),2)=1)*D37*G3:G7)
(no need for the preceding: "--")
---
=SUMPRODUCT((MOD(ROW(D3
7),2)=1)*D37*G3:G7)(no need for the preceding: "--")
---
R
Rick Rothstein \(MVP - VB\)
Well, there is always this way...
=G3*D3+G5*D5+G7*D7
Rick
=G3*D3+G5*D5+G7*D7
Rick
E
Eric
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
8) BUT ONLY
IF THE FIGURES IN P38 ARE POSITIVE.
Then I need, for another cell, =SUM(1:31!P38) BUT ONLY IF FIGURES IN P38
ARE NEGATIVE.
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
8) BUT ONLYIF THE FIGURES IN P3
8 ARE POSITIVE.Then I need, for another cell, =SUM(1:31!P3
8) BUT ONLY IF FIGURES IN P38ARE NEGATIVE.
M
Max
Eric,
Suggest you put in a fresh new posting for your new query
---
Suggest you put in a fresh new posting for your new query
---