Please use sumproduct formula which will be :

=(sumproduct((Page1(rangeA="MC)*(rangeB))*2.20462) +(sumproduct((Page2(rangeA="MC)*(rangeB))*2.20462) +(sumproduct((Page3(rangeA="MC)*(rangeB))*2.20462)

Where rangeA = $C$15:$C$71
and rangeB = $H$15:$H$71

Thanks,

Manish Bajpai



"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

--
Message posted via http://www.officekb.com