Thread: SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil Neil is offline
external usenet poster
 
Posts: 173
Default 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