Hi everybody,

First of all I wish you all a very Happy and Prosperous new year
2006.

I have 10 work sheets, in the 11th sheet I want to sum a column based
on the column F value. I'm givivg you an example for this.

In 11th work sheet in column F I have this formula.

=sumif('sheet1!'D1:D100="X",'sheet1!'f1:f100)+sumi f('sheet2!'D1:D100="X",'sheet2!'f1:f100)+sumif('sh eet3!'D1:D100="X",'sheet3!'f1:f100)+sumif('sheet4! 'D1:D100="X",'sheet4!'f1:f100)+.....sumif('sheet10 !'D1:D100="X",'sheet10!'f1:f100).
Some times the sheets may go up to 50.

So I need a nested formula like
sumif(Sheet1:sheet10d1:d100="x",sheet1:sheet10f1:f 100)

If any body hae suggestions plz give me.

Thanks and Regards

Ramana