SUM

[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.

 

[RagDyeR]

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.

 

[ekskumar]

Thankyou very much it works, really appriciate it.

 

[RagDyeR]

You're welcome, and appreciate the feed-back.