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

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