Please Solve my promlem if any body can ?

Closed
Shehzad Naqvi - Sep 28, 2015 at 01:15 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 28, 2015 at 02:59 PM
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 August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 28, 2015 at 02:59 PM
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
0