View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Svend Svend is offline
external usenet poster
 
Posts: 3
Default How do I add the value in every fifth cell in a column?

I could not get this solution to generate the correct answer. But that may
be because I do not understand the entry "...CT(--(M...". Thanks for your
help.

"Elkar" wrote:

You could try something like this:

=SUMPRODUCT(--(MOD(ROW(A1:A23),6)=3),A1:A23)

HTH
Elkar


"Svend" wrote:

The spreadsheet has ten columns, with five rows of data. This format is
repeated x number of times, with a line break between sets. I want to add the
values in column A, row three in each set of data. As an example:
A3 + A9 + A15 + A21, etc. Is this possible in Excel 2007?