Hi,
I have a row of cells in an Excel 2010 worksheet (A2:X2) which I want to total the values and display in cell Y2. However, I only want to total every third cell in the row.
For example, =SUM(C2, F2, I2, L2, O2, R2, U2, X2)
Is there a formula I can use which will only SUM every third cell in a range (row) without my having to enter each individual cell reference, as shown above ?
Thanks
Toco
Open in new window