Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM every 4th cell in a row
I have a spreadsheet which will build up over the next few weeks with each
weeks results adding four columns of data to the sheet sheet1. I then want to perform analysis on the data in another sheet sheet2 eg. In cell A1: SUM(sheet1!B8,sheet1!F8,sheet1!J8,etc, and in cell B1: COUNT(sheet1!B8,sheet1!F8,sheet1!J8,etc, etc Is there a way of calculating every 4th cell in a row. There will be several weeks of data and doing this long-hand (as above) is time consuming. I dont yet know how many weeks of data there will be and I dont want to have to add extra terms to the COUNT, SUM, etc each time I add a new week. Perhaps there is a way of creating a Range of this nature? I clutch at straws. Can you help? |