Sum every other cell?

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

bookmanjb

I just previewed the post below and saw that the format didn't hold.
don't know how to make it look right. I hope you can figure it out fro
what you see.

Sample rows:

Day 1 Day 2
Day 3
Category #Books $$$ #Books $$$
#Books $$$
1 4 16.00 0
0.00 7 29.95
2 3 17.50 3
17.50 3 17.50
3 0 0.00 6
24.25 8 37.75


I want a formula or function that will allow me to sum all the Book
cells in a row and all the dollar amounts. In other words, a formula o
function that will sum every other cell. Let me know if that's no
clear. I know I can do it laboriously with alternate worksheets o
simply adding all the cells and then filling across and down. I'd lik
something more elegant than those two options. I appreciate you
interest in my little problem.
 
What formulas did you use?
--


Regards,

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


I just previewed the post below and saw that the format didn't hold. I
don't know how to make it look right. I hope you can figure it out from
what you see.

Sample rows:

Day 1 Day 2
Day 3
Category #Books $$$ #Books $$$
#Books $$$
1 4 16.00 0
0.00 7 29.95
2 3 17.50 3
17.50 3 17.50
3 0 0.00 6
24.25 8 37.75


I want a formula or function that will allow me to sum all the Books
cells in a row and all the dollar amounts. In other words, a formula or
function that will sum every other cell. Let me know if that's not
clear. I know I can do it laboriously with alternate worksheets or
simply adding all the cells and then filling across and down. I'd like
something more elegant than those two options. I appreciate your
interest in my little problem.
 
Back
Top