Connest two sheets like i have counts in sheet 1 and want total in sheet 2

khare_anshul · #1 Jan 18, 2008, 09:18 PM

Connest two sheets like i have counts in sheet 1 and want total in sheet 2 .

mdosh01 · Jan 20, 2008, 05:39 PM

I think we need more details to help you on this one. But let me take a stab at it. You have a series of numbers in one worksheet and you want the sum of those to appear in another worksheet.

So, worksheet 1, I have the following entries:

Cell - Value
A1 - 10
A2 - 5
A3 - 17
A4 - 99

In worksheet 2 I would enter the following formula to have the total of cells A1 to A4 (131)appear in worksheet 2:

=SUM(Sheet1!A1:A4)

This assumes the tab for worksheet 1 is "Sheet1"



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!