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

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"