Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif on multiple pages?---not just one page
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
I'm just interested in summing the cells that contain "MC" in the range i
defined, but wasn't sure how to do more than one page.... Is sumproduct the function for this??? thanks jeremy -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
"Manish Bajpai" wrote...
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 ) .... What the heck is Page1(..), Page2(..) and Page3(..)? Answer: syntactically, Excel would treat them as function calls. Since they're not built-in functions, Excel would attempt to resolve them as udfs. However, you failed to include the necessary code for these udfs (or mention that they'd need to be udfs), so your wonderful formula would return a #NAME? error. Do you know what you're doing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ONE PAGE REPORT WANTS TO PRINT 1311 pages in each copy, WHY? | Excel Discussion (Misc queries) | |||
My scaling is set to print 1x1 pages. But it prints 1000's of page | Excel Worksheet Functions | |||
need to reducing pages....i need to put the bottom part of a page. | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
combining multiple pages from Web automatically | Excel Discussion (Misc queries) |