SUMIF function

[Guest]

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?

 

[T. Valko]

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)

 

[Guest]

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]

See replies to your other post.