| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Make a formula that adds every 4th cell in a column indefinately?
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? |
|
#2
|
|||
|
|||
|
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 Ben Mehling wrote: 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? |
|
#3
|
|||
|
|||
|
Excellent! Thank you Roger!
"Roger Govier" wrote: 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 Ben Mehling wrote: 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? |
|
#4
|
|||
|
|||
|
You're welcome Ben, thanks for the feedback.
Regards Roger Govier Ben Mehling wrote: Excellent! Thank you Roger! "Roger Govier" wrote: 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 Ben Mehling wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| looking for a formula | Excel Worksheet Functions | |||
Linear Mode
