Associate
- Joined
- 4 May 2004
- Posts
- 2,215
- Location
- NE England
Hi Guys,
A need help on a SUM and cell reference problem.
I have a table as follows:
I SUM A to C cells:
As normal. My problem is now repeating the pattern:
I would like to click and drag the pattern as above.
However, excel produces this:
How do I get excel to do what I want?
A need help on a SUM and cell reference problem.
I have a table as follows:
PHP:
A B C D E F G
6 89 54 21 36 55 98I SUM A to C cells:
PHP:
=SUM(A1:C1)As normal. My problem is now repeating the pattern:
PHP:
=SUM(A1:C1), =SUM(D1:F1),...I would like to click and drag the pattern as above.
However, excel produces this:
PHP:
=SUM(A1:C1), =SUM(B1:D1),...How do I get excel to do what I want?