Hi

Something like =SUM(Sheet2:Sheet3!B2:D2). Start the formula =SUM( ,then
select the sheets you want and then the range.

regards
Peter

"teeblackman" wrote:

I am setting up monthly spread sheets for tax purposes. I have each month
set up separately and a total page. I want to know if you can put a formula
in on the total page (which is a separate worksheet in my workbook) that will
add up a single row from each worksheet an d give me a total for my total
page.