| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use sumif with criteria including sheet name
I have a workbook which will be added new worksheets to by others. The
worksheet names are all month names. I want to do a sumif according to the name of the worksheets, i.e. according to the month specified by the worksheet name. I am using the following formula, and it doesn't work: =SUMIF(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255), "=*Sept*", STATISTICS:BLANK!C1) with an intention to sum up the C1's in all sheets with the sheet's name including the string "Sept". Could anybody please help me out with this, thanks a bunch in advance! Theresa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average with 2 criteria including month | Excel Worksheet Functions | |||
| Sumif with two criteria including a date range | Excel Discussion (Misc queries) | |||
| How do I count frequency based on 2 criteria (including month) | Excel Worksheet Functions | |||
| How do I do a sumif function not including hidden rows? | Excel Worksheet Functions | |||
| coutif with 3 criteria including brackets | Excel Worksheet Functions | |||
Threaded Mode
