yes. For Example, I can insert the following formula with accurate
results:

=SUMIF(DBType,A4,DBAmount)+SUMIF(Sheet2!A11:A17,Sh eet1!A4,Sheet2!B11:B17)+SUMIF(Sheet3!A11:A17,Sheet 1!A4,Sheet3!B11:B17)+SUMIF(Sheet4!A11:A17,Sheet1!A 4,Sheet4!B11:B17)+SUMIF(Sheet5!A11:A17,Sheet1!A4,S heet5!B11:B17)+SUMIF(Sheet6!A11:A17,Sheet1!A4,Shee t6!B11:B17)+SUMIF(Sheet7!A11:A17,Sheet1!A4,Sheet7! B11:B17)+SUMIF(Sheet8!A11:A17,Sheet1!A4,Sheet8!B11 :B17)+SUMIF(Sheet9!A11:A17,Sheet1!A4,Sheet9!B11:B1 7)+SUMIF(Sheet10!A11:A17,Sheet1!A4,Sheet10!B11:B17 )+SUMIF(Sheet11!A11:A17,Sheet1!A4,Sheet11!B11:B17) +SUMIF(Sheet12!A11:A17,Sheet1!A4,Sheet12!B11:B17)+ SUMIF(Sheet13!A11:A17,Sheet1!A4,Sheet13!B11:B17)+S UMIF(Sheet14!A11:A17,Sheet1!A4,Sheet14!B11:B17)+SU MIF(Sheet15!A11:A17,Sheet1!A4,Sheet15!B11:B17)+SUM IF(Sheet16!A11:A17,Sheet1!A4,Sheet16!B11:B17)+SUMI F(Sheet17!A11:A17,Sheet1!A4,Sheet17!B11:B17)+SUMIF (Sheet18!A11:A17,Sheet1!A4,Sheet18!B11:B17)+SUMIF( Sheet19!A11:A17,Sheet1!A4,Sheet19!B11:B17)+SUMIF(S heet20!A11:A17,Sheet1!A4,Sheet20!B11:B17)+SUMIF(Sh eet21!A11:A17,Sheet1!A4,Sheet21!B11:B17)

This is a very clumsy solution, and may start to break down after a
large number of sheets are entered. There must be a more concise
method to achieve this result.


--
bruce42
------------------------------------------------------------------------
bruce42's Profile: http://www.excelforum.com/member.php...o&userid=24609
View this thread: http://www.excelforum.com/showthread...hreadid=381963