| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula will not work
I have a workbook set up which has year-to-date running totals.
The report is pulling the previous months numbers from different sheets that I have added to the end of the workbook once the month is complete. The formula I have been using, =SUMIF('Int Mar 07'!A:A,"four winds",'Int Mar 07'!B:B) has worked fine until this month. When I change the formula to reflect April (the latest month), all I get are "0"'s. When I tested the formula to pull from different sheets, still within the workbook, it computes fine. Could there be something corrupt with the April sheet I just added? I'm relatively new to Excel so any information would be greatly appreciated! Thanks! Indymanny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cant quite get this formula to work: | Excel Worksheet Functions | |||
| The same formula doesn't work again? | Excel Worksheet Functions | |||
| Why does this Formula work? | Excel Worksheet Functions | |||
| FORMULA DOESN'T WORK | Excel Discussion (Misc queries) | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Threaded Mode
