View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Monique Monique is offline
external usenet poster
 
Posts: 60
Default sum of every 4th cell in a row.

I am trying to set up a spread sheet where each element in a row has four
different columns of data. At the end of the row I need to do various
calculations based on the sum of each column for each element.

BX5 = C5+G5+K5+O5+etc.
BY5 = D5+I5+L5+P5,+etc

I've seen several similar calculations using data in column, but not in rows
and I have not been able to translate that info into rows.

Monie