Sum every other cell?

  • Thread starter Thread starter bookmanjb
  • Start date Start date
B

bookmanjb

I own a used-book shop. I have an Excel SS to track how many books pe
day I sell in each of 28 categories and the $$$ I take in for eac
category. So there's two columns for each day: #books & $$$.
therefore want to add every odd-numbered cell in a row to get the tota
number of books for a category in a given period of days and ever
even-numbered cell in the same row for the the total $$$. Is there
simple formula or function for this
 
Hi
not really sure about your data layout. Could you post some example
rows (plain text - no attachments please)
 
one way:

Odd (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(IF(MOD(ROW(A1:A100),2),A1:A100,0))

Even (also array-entered):

=SUM(IF(MOD(ROW(A1:A100),2),0,A1:A100))
 
Hi ____,
One way would be to place =SUM(
where you want the total then select the cells
you want to add holding down the CTRL key
i.e. B2 D2 F2 H2 J2 L2 N2 etc.
then on the address bar enter the closing paren.

To create a sum of those sums in cell P32
after the end use a formula like
P32: =SUM(P$2,OFFSET(P32,-1,0))
 
Whoops, missed the values in rows, not columns. Try (both array-entered):


Odd:

=SUM(IF(MOD(COLUMN(B2:IV2),2),B2:IV2,0))

Even:

=SUM(IF(MOD(COLUMN(B2:IV2),2),0,B2:IV2))
 
Assume 56 columns - A to BD.
In BE - for EVEN:
=SUMPRODUCT((MOD(COLUMN(A10:BD10),2)=0)*A10:BD10)

In BF - for ODD:
=SUMPRODUCT((MOD(COLUMN(A10:BD10)-1,2)=0)*A10:BD10)

--

HTH,

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


I own a used-book shop. I have an Excel SS to track how many books per
day I sell in each of 28 categories and the $$$ I take in for each
category. So there's two columns for each day: #books & $$$. I
therefore want to add every odd-numbered cell in a row to get the total
number of books for a category in a given period of days and every
even-numbered cell in the same row for the the total $$$. Is there a
simple formula or function for this?
 
Back
Top