| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum across range of sheets for a cost code
I'm trying to create a summary sheet at the end of a workbook that will
automatically total the amount spent from a specific cost code. My first sheet is "template" and my last sheet is "Totals", cell O32 contains the total spent and cell H38 contains the cost code of each oder. Each time an order is made, the template sheet is copied and renamed according to vendor and date and placed in front of the "Totals" sheet. I've tried: =SUMIF(template:Totals!H38,"4960.114.44114",templa te:Totals!O32) Does anyone have suggestions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CODE 2 SELECT SHEETS LISTED IN A RANGE | Excel Discussion (Misc queries) | |||
| Type a cost code in one cell and discription in an other | Excel Worksheet Functions | |||
| Tracking Cost Price from Different Sheets | Excel Discussion (Misc queries) | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| Help creating a cost range | Excel Discussion (Misc queries) | |||
Threaded Mode
