add cells on multiple worksheets using specific criteria
 

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?

add cells on multiple worksheets using specific criteria
 

=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)



"edwgolz" wrote in message
...
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?

add cells on multiple worksheets using specific criteria
 

I used this formula with a project and came up with a #NAME error. It looks
like =SUMPRODUCT(SUMIF(INDIRECT("'"&first:last&"'!B17:B 42"),"2x4x16
PT",INDIRECT("'"&first:last&"'!C17:B42"))) what am I doing wrong. Frustrated!

"Bob Phillips" wrote:


=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)



"edwgolz" wrote in message
...
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?