SUMIF or SUMPRODUCT

[Guest]

I am working ona summary page. I would like to summarize 20 seperate
worksheets. On each worksheet I have a line item number, and I would like
to summarize all the pages with the same line item number. I have tried
SUMIF and SUMPRODUCT. SUMIF just sends back a # VALUE error. UGH!
SUMPRODUCT never would take, kept telling me there was an error in my formula.

SUMIF('01:20'!E$,1,'01:20'!W15:W156)

That is the sumif formula I have been trying. Any help her eis greatly
appreciated!!

Thank You.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(SUMIF(INDIRECT("'" & TEXT(ROW(1:20),"00") &
"'!E15:E156"),1,INDIRECT("'" & TEXT(ROW(1:20),"00") & "'!W15:W156")))

this sums the values from column W15:W156 where the value in column E
equals '1'

 

[Don Guillett]

IF!!! they are all in the SAME place then
=sum(sheet1:sheet21!a1) will do it

 

[Guest]

Hi again Frank
the $ beside the E in my formula was actually supposed to be a 4. Sorry
about that. I need to look at cell E4 on each page and if it matches my
criteria, then I want to sum a column on that page. Am I going to need to
add a column to each page to list the line item # ?