I am trying to use the sumif function but instead of a range of cells to
add(based on a sumif "criteria") I want to add only specific cells within a
range(i.e. a4,a14,a24,a34).
is this possible?

If you only have those 4 cells:

=SUM(A4,A14,A24,A34)

But I'm "guessing" that you have many more than those 4 cells. So, try this:

=SUMPRODUCT(--(MOD(ROW(A4:A34)-MIN(ROW(A4:A34))+1,10)=1),A4:A34)

--
Biff
Microsoft Excel MVP


"eric" wrote in message
...
I am trying to use the sumif function but instead of a range of cells to
add(based on a sumif "criteria") I want to add only specific cells within
a
range(i.e. a4,a14,a24,a34).
is this possible?

THanks for the help. Could you answer another ? How do I add a cell's
information to a fomula only when it becomes relevant(i.e. the cell next to
it has some value posted to it).
In my spreadsheet I have 5 weeks of info. I want to have a running % of
points accumulated throughout the 5 weeks but only want the each weeks
possible total points to be added when that week has been completed.
Does that make sense?

"T. Valko" wrote:

If you only have those 4 cells:

=SUM(A4,A14,A24,A34)

But I'm "guessing" that you have many more than those 4 cells. So, try this:

=SUMPRODUCT(--(MOD(ROW(A4:A34)-MIN(ROW(A4:A34))+1,10)=1),A4:A34)

--
Biff
Microsoft Excel MVP


"eric" wrote in message
...
I am trying to use the sumif function but instead of a range of cells to
add(based on a sumif "criteria") I want to add only specific cells within
a
range(i.e. a4,a14,a24,a34).
is this possible?

See replies to your other post.

--
Biff
Microsoft Excel MVP


"eric" wrote in message
...
THanks for the help. Could you answer another ? How do I add a cell's
information to a fomula only when it becomes relevant(i.e. the cell next
to
it has some value posted to it).
In my spreadsheet I have 5 weeks of info. I want to have a running % of
points accumulated throughout the 5 weeks but only want the each weeks
possible total points to be added when that week has been completed.
Does that make sense?

"T. Valko" wrote:

If you only have those 4 cells:

=SUM(A4,A14,A24,A34)

But I'm "guessing" that you have many more than those 4 cells. So, try
this:

=SUMPRODUCT(--(MOD(ROW(A4:A34)-MIN(ROW(A4:A34))+1,10)=1),A4:A34)

--
Biff
Microsoft Excel MVP


"eric" wrote in message
...
I am trying to use the sumif function but instead of a range of cells to
add(based on a sumif "criteria") I want to add only specific cells
within
a
range(i.e. a4,a14,a24,a34).
is this possible?