Hi Bob!

That returns #VALUE! due to the array of range references being passed to
Sumproduct.

=SUMPRODUCT(TRANSPOSE(N(INDIRECT("'"&H1:H2&"'!A1") ))*(N(INDIRECT("'"&H1:H2&"'!A1"))<100))

Also, if:

Sheet1A1 = 100
Sheet2A1 = 10

Formula returns: 110

Biff

"Bob Phillips" wrote in message
...
=SUMPRODUCT(TRANSPOSE((INDIRECT("'"&H1:H2&"'!A1")) *(INDIRECT("'"&H1:H2&"'!A1
")<100)))

--
HTH

Bob Phillips

"Biff" wrote in message
...
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