sumif on multiple pages?---not just one page

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "jeremy via OfficeKB.com" <forum@xxxxxxxxxxxxxxxxxxx>
Date: Thu, 09 Jun 2005 21:14:22 GMT

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.20462

Any help?

Jeremy

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

Follow-Ups:
- Re: sumif on multiple pages?---not just one page
  - From: Domenic
- RE: sumif on multiple pages?---not just one page
  - From: Manish Bajpai

Prev by Date: Re: function execution
Next by Date: Copy drop down boxes and associate to cells dynamically in excel
Previous by thread: How do I ignore cells in Excel?
Next by thread: RE: sumif on multiple pages?---not just one page
Index(es):
- Date
- Thread

Relevant Pages

Re: sumif on multiple pages?---not just one page
... ....where A1 contains your number for your first sheet/page, such as 1, ... > Here's a function that summarize cells on one page--but I don't know how to ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Re: Simple SQL question
... Jeremy wrote: ... A better subject line might have been "Remove multiple ... spaces from a string using SQL". ... Prev by Date: ...
(comp.databases.oracle.server)
RE: sumif on multiple pages?---not just one page
... and rangeB = $H$15:$H$71 ... Manish Bajpai ... "jeremy via OfficeKB.com" wrote: ... > Here's a function that summarize cells on one page--but I don't know how to ...
(microsoft.public.excel.worksheet.functions)