Sumif across 10 sheets.

Sums cell A1 on 10 worksheets if A1 <100.

The 10 sheets to sum are listed in the range H1:H10

=SUMPRODUCT(SUMIF(INDIRECT("'"&H1:H10&"'!A1"),"<10 0"))

If you use the default sheet names: Sheet1, Sheet2, Sheet3 etc there's no
need to list the names in a range:

=SUMPRODUCT(SUMIF(INDIRECT("'sheet"&ROW(1:10)&"'!A 1"),"<100"))

Biff

"Bob Phillips" wrote in message
...
Why, it is hard to think of any reason to do so?

--
HTH

Bob Phillips

"Abdul Waheed" <Abdul wrote in message
...
Dear Sir,

I want to use sumif function inside sumproduct function Pls help me out