Try...

=SUMPRODUCT(SUMIF(INDIRECT("'"&ROW(INDIRECT(A1&":" &B1))&"'!C15:C71"),"MC*
",INDIRECT("'"&ROW(INDIRECT(A1&":"&B1))&"'!H15:H71 "))*2)

....where A1 contains your number for your first sheet/page, such as 1,
and B1 contains your number for your last sheet/page, such as 12.

Hope this helps!

In article ,
"jeremy via OfficeKB.com" wrote:

Here's a function that summarize cells on one page--but I don't know how to
make it summarize on multiple pages....

=SUMIF('1'!$C$15:$C$71,"MC*",'1'!$H$15:$H$71)*2.20 462

Any help?

Jeremy