SUMIF or SUMPRODUCT

F

frustratedwthis

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.
 
F

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'
 
F

frustratedwthis

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 # ?
 
Top