Please Solve my promlem if any body can ?

Closed
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
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 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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