Please Solve my promlem if any body can ?

Closed
Shehzad Naqvi - 28 Sep 2015 à 13:15
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 28 Sep 2015 à 14:59
Hello,
if i make 10 invoices for a company on sheet 1 to sheet 10, each invoice has amount about Rs. 10000/- i need a auto covering letter on sheet 11. which contain sum of all sheets of invoices and less detail more then actual invoice. how can i do that please help and tell me the formula


Thanks
Shehzad Naqvi


1 response

Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
28 Sep 2015 à 14:59
Shehzad Naqvi, Good afternoon.

As ALL your Sheets have same layout, you can try this kind of formula:
=SUM(Sheet1:Sheet10!A1)

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão