add cells on multiple worksheets using specific criteria

  • Thread starter Thread starter edwgolz
  • Start date Start date
E

edwgolz

I have a workbook that has a sheet for each month with vendor data. I'd like
to add all the cells for each particular vendor on an overview sheet. Any
ideas?
 
=SUMPRODUCT(SUMIF(INDIRECT("'"&C1:C3&"'!A2:A20"),"vendor",INDIRECT("'"&C1:C3&"'!B2:B20")))

where C1:C3 is a range housing the relevant sheetnames in
separate cells.



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I used this formula with a project and came up with a #NAME error. It looks
like =SUMPRODUCT(SUMIF(INDIRECT("'"&first:last&"'!B17:B42"),"2x4x16
PT",INDIRECT("'"&first:last&"'!C17:B42"))) what am I doing wrong. Frustrated!
 
Back
Top