Email question

  24dragon 16:10 27 May 04
Locked

Hi, can someone tell me how to do the following, please?

Sheet 1 contains 2 columns for each month, sheet 2 has 1 column for each month. This is linked to the first sheet, and I want to add both totals from sheet 1 to appear as a single total on the second sheet. But, if I format sheet 2, col B to equal sheet 1 col A + B, then drag across sheet 2, I get on sheet 2 A+B, then B+c, C+D etc, instead of A+B, C+D, E+F.

Bit complicated to explain, but I've got a feeling brackets come into it somewhere!

Thanks in advance

  Wak 16:17 27 May 04

Is this an Email question or an EXCEL question???
The latter, I think!

  exdragon 17:20 27 May 04

You're right, of course! I can't change the header, though, can I?

  Shas 17:32 27 May 04

Start a new thread with Excel in the title, I'm sure Vog or one of the other Excel masters will pick it up. I have done what you're trying to do before but can't remember exactly how, I think it's through the Insert > Function menu.

  exdragon 18:07 27 May 04

Re entered as Excel question!

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…