Applying same formula on pre-determined cells

Hi, Andy. If you are asking for a way to use SUM on various cells throughout the worksheet, yes you can. Follow this format:

=SUM(H12,H16,I17,K3,O4,N19,D22,A25) where each cell is listed separately (need not be in any specific order) and each separated by a comma ','.

You can also SUM various ranges *and* individual cells using this format:

=SUM(H12:H13,H16,I17:I21,K3,O3:O4,N19:N26,D22,A25)

If this is not what you are looking for, please reply with more details.

HTH

Bruce

I am still not clear on your desire. Your formula, as written: =SUM(A:Q) will add *all* rows (from row 1 to row 65536) in all columns from A through Q.

Do you mean =SUM(A1:Q1) and =SUM(A15:Q15), etc.

Where on your sheet are you going to place these formulas? If you want the total at the end of each desired row (say in Row 1, Row 15, etc.) simply place =SUM(A1:Q1) in R1, then copy/paste to R15 and so on.

If you want this calculation on another sheet, place this formula in row 1 and copy down. It will return the sum of every 15th row of sheet1 (i.e. rows 1, 15, 30, 45....) per your example.

In row 1 of the other sheet, place this formula:

=SUM(INDIRECT("Sheet1!A"&(ROW(1:1)):INDIRECT("Sheet1!Q"&(ROW(1:1)))

In row 2 place this formula and copy down as far as needed:

=SUM(INDIRECT("Sheet1!A"&(ROW(2:2)*15)):INDIRECT("Sheet1!Q"&(ROW(2:2)*15)))

Good Luck

Bruce