SUM

  • Thread starter Thread starter ekskumar
  • Start date Start date
E

ekskumar

I was trying to sum up a particular range e.g A1: BC1 but in between every
cell contains another formula which calculates the cost, I need to skip these
cells that is every alternate cells and should sum only the cells which
contains a number. Presently am using this formula to get the result =sum
(A1,A3,A5) or =+A5+A3+A5, the problem with the formula is that when we try to
insert a column we need to update the formula as well, would appreciate if
can advice me with any other formula to get the same result.
 
This will sum A1, C1, E1, ...etc.

=SUMPRODUCT((MOD(COLUMN(A1:BC1),2)=1)*(A1:BC1))

This will sum B1, D1, F1, ...etc.

=SUMPRODUCT((MOD(COLUMN(A1:BC1),2)=0)*(A1:BC1))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I was trying to sum up a particular range e.g A1: BC1 but in between every
cell contains another formula which calculates the cost, I need to skip
these
cells that is every alternate cells and should sum only the cells which
contains a number. Presently am using this formula to get the result =sum
(A1,A3,A5) or =+A5+A3+A5, the problem with the formula is that when we try
to
insert a column we need to update the formula as well, would appreciate if
can advice me with any other formula to get the same result.
 
Back
Top