SUM
 

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.

SUM
 

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!
================================================== ===


"ekskumar" wrote in message
...
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.

SUM
 

Thankyou very much it works, really appriciate it.

"ekskumar" wrote:

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.

SUM
 

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

Regards,

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

"ekskumar" wrote in message
...
Thankyou very much it works, really appriciate it.

"ekskumar" wrote:

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.