Make a formula that adds every 4th cell in a column indefinately?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Office 2003 I need to make a formula that will add up every fourth cell in
a given column (i.e. A8,A12,A16,A20,etc). This range extends beyond 30
entries (one for each work day for a year) so entering each one individually
will not work. I haven't been able to find anything in the Excel help that
has been useful. Does anyone know how to accomplish this?
 
Hi Ben
One way
=SUMPRODUCT(--(MOD(ROW(A8:A1000),4)=0),A8:A1000)
Change range to suit but make sure the ranges are of identical size.

Regards

Roger Govier
 
Excellent! Thank you Roger!

Roger Govier said:
Hi Ben
One way
=SUMPRODUCT(--(MOD(ROW(A8:A1000),4)=0),A8:A1000)
Change range to suit but make sure the ranges are of identical size.

Regards

Roger Govier
Click to expand...
 
You're welcome Ben, thanks for the feedback.
Regards

Roger Govier
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Every 4th column in a range tied to a control cell 1
adding every third column 1
I Need Help With A Complex Formula 6
Excel, how to count every 4th cell in column to see if occupied? 4
Sum a column that contains if statement that reference cells with 13
CountIf previous cell formula 0
Averaging every 5th cell while omitting zeros 4
How do I input these formulas into cells that I want written in? 4

Back
Top