How do I add the value in every fifth cell in a column?
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?
|