Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
I need to total the of identical columns on 3 different pages with reference
to the previous column on each page. I can us the SUMIF when the columns are all on one page, how do you make multiple range columns? Page 1 Page 2 Page 3 Page 4 1 20 1 10 3 10 5 10 2 30 1 10 3 10 5 10 3 20 2 10 4 10 6 10 4 30 2 10 4 10 6 10 5 20 2 10 4 10 -- Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
SUMIF is not very good with 3-D ranges (i.e. useless!!). However, you
can do something like this: =SUMIF(from Page1) + SUMIF(from Page2) + SUMIF(from Page3) where I am assuming that Page1, Page2 etc are sheet names. Alternatively, you can have your SUMIFs on each sheet, giving their results to a specific range of cells, and then on your summary sheet you could use: =SUM(Page1:Page3!cell_ref/range) Hope this helps. Pete On Jan 26, 9:07*pm, Neil wrote: I need to total the of identical columns on 3 different pages with reference to the previous column on each page. I can us the SUMIF when the columns are all on one page, how do you make multiple range columns? * * Page 1 * * * * * * * * *Page 2 * * * * * * * * * * * * * Page 3 * * * * * * * * * * * * *Page 4 1 * * * 20 * * *1 * * * 10 * * *3 * * * 10 * * *5 * * * 10 2 * * * 30 * * *1 * * * 10 * * *3 * * * 10 * * *5 * * * 10 3 * * * 20 * * *2 * * * 10 * * *4 * * * 10 * * *6 * * * 10 4 * * * 30 * * *2 * * * 10 * * *4 * * * 10 * * *6 * * * 10 5 * * * 20 * * *2 * * * 10 * * *4 * * * 10 * * * * * * * -- Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Sumif | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |