Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum every 10th cell in a range of cells?
Is it possible to Sum every 10th cell in a range of cells (i.e.
a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
#2
|
|||
|
|||
JKJ95
=SUMPRODUCT((MOD(ROW(A1:A500),10)=0)*A1:A500) HTH, Bernie MS Excel MVP "JKJ95" wrote in message ... Is it possible to Sum every 10th cell in a range of cells (i.e. a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
#3
|
|||
|
|||
=SUMPRODUCT((A1:A500)*(MOD(ROW(1:500),10)=0))
Bob Umlas Excel MVP "JKJ95" wrote in message ... Is it possible to Sum every 10th cell in a range of cells (i.e. a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
#4
|
|||
|
|||
Try...
=SUMPRODUCT(--(MOD(ROW(A1:A500)-CELL("row",A1)+1,10)=0),A1:A500) In instances where you want to sum every 10th cell starting from A1, change the +1 part of the formula to +0... =SUMPRODUCT(--(MOD(ROW(A1:A500)-CELL("row",A1)+0,10)=0),A1:A500) Hope this helps! In article , "JKJ95" wrote: Is it possible to Sum every 10th cell in a range of cells (i.e. a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
#5
|
|||
|
|||
=SUM(IF(MOD(ROW(A1:A500),10)=0,A1:A500))
Entered with Ctrl+Shift+Enter rather than just enter since this is an array formula. -- Regards, Tom Ogilvy "JKJ95" wrote in message ... Is it possible to Sum every 10th cell in a range of cells (i.e. a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
#6
|
|||
|
|||
=SUMPRODUCT(--(MOD(ROW(A1:A500),10)=0),A1:A500)
"JKJ95" wrote: Is it possible to Sum every 10th cell in a range of cells (i.e. a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
#7
|
|||
|
|||
Try something like this:
=SUMPRODUCT(--(MOD(ROW($A$10:$A$30)-ROW($B$10),10)=0)*$A$10:$A$30) -- Regards, Ron |
#8
|
|||
|
|||
=SUMPRODUCT(((MOD(A1:A500,10)=0)*A1:A500))
Jerry JKJ95 wrote: Is it possible to Sum every 10th cell in a range of cells (i.e. a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
#9
|
|||
|
|||
You probably meant
=SUMPRODUCT(((MOD(ROW(A1:A500),10)=0)*A1:A500)) Alok Joshi "Jerry W. Lewis" wrote: =SUMPRODUCT(((MOD(A1:A500,10)=0)*A1:A500)) Jerry JKJ95 wrote: Is it possible to Sum every 10th cell in a range of cells (i.e. a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
#10
|
|||
|
|||
True
Alok wrote: You probably meant =SUMPRODUCT(((MOD(ROW(A1:A500),10)=0)*A1:A500)) Alok Joshi "Jerry W. Lewis" wrote: =SUMPRODUCT(((MOD(A1:A500,10)=0)*A1:A500)) Jerry JKJ95 wrote: Is it possible to Sum every 10th cell in a range of cells (i.e. a10+a20+a30....in a range of a1:a500) without entering every cell manually? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Need to find the right-most cell value in a string of cells | Excel Worksheet Functions | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions |