| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count across multiple columns, using specific criteria | Excel Discussion (Misc queries) | |||
| How do I Provide a specific result given multiple criteria? | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions | |||
Linear Mode
