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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula will not work
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula will not work
Maybe "four winds" doesn't match any cell in April's column A?
Maybe the values in column B of that worksheet aren't numbers--maybe they just look like numbers (text masquerading as numbers). If you put these in a couple of empty cells in the April worksheet =count(B:B) =counta(B:B) do they match? The first counts numbers. The second counts non-empty cells. Indymanny wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula will not work
Thanks, Dave for the reply. Unfortunately, nothing is working as of yet. I've
double checked the names are correct ("four winds", etc.), made sure all of column B on the April document are Numbers, and tried your "count" formula - which when I did the first one, it gave me an error that it was trying to do a "circular reference", and the second one (counta) just gave me a "0". Should I be checking something else on the April sheet? "Dave Peterson" wrote: Maybe "four winds" doesn't match any cell in April's column A? Maybe the values in column B of that worksheet aren't numbers--maybe they just look like numbers (text masquerading as numbers). If you put these in a couple of empty cells in the April worksheet =count(B:B) =counta(B:B) do they match? The first counts numbers. The second counts non-empty cells. Indymanny wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula will not work
Put the formulas on the April worksheet, but don't use a cell in column B.
If =count(B:B) returns 0, then you don't have any numbers in column B. If =counta(B:B) returns 0, then you don't have anything in that column. Indymanny wrote: Thanks, Dave for the reply. Unfortunately, nothing is working as of yet. I've double checked the names are correct ("four winds", etc.), made sure all of column B on the April document are Numbers, and tried your "count" formula - which when I did the first one, it gave me an error that it was trying to do a "circular reference", and the second one (counta) just gave me a "0". Should I be checking something else on the April sheet? "Dave Peterson" wrote: Maybe "four winds" doesn't match any cell in April's column A? Maybe the values in column B of that worksheet aren't numbers--maybe they just look like numbers (text masquerading as numbers). If you put these in a couple of empty cells in the April worksheet =count(B:B) =counta(B:B) do they match? The first counts numbers. The second counts non-empty cells. Indymanny wrote: 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 -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula will not work
While I was at lunch, a co-worker took a shot at the problem. All she did was
re-type all the numbers in the B column on the April worksheet and then it worked. Is there a reason for this, so I know what to watch out for the next time? Again, thanks for all your help! "Dave Peterson" wrote: Put the formulas on the April worksheet, but don't use a cell in column B. If =count(B:B) returns 0, then you don't have any numbers in column B. If =counta(B:B) returns 0, then you don't have anything in that column. Indymanny wrote: Thanks, Dave for the reply. Unfortunately, nothing is working as of yet. I've double checked the names are correct ("four winds", etc.), made sure all of column B on the April document are Numbers, and tried your "count" formula - which when I did the first one, it gave me an error that it was trying to do a "circular reference", and the second one (counta) just gave me a "0". Should I be checking something else on the April sheet? "Dave Peterson" wrote: Maybe "four winds" doesn't match any cell in April's column A? Maybe the values in column B of that worksheet aren't numbers--maybe they just look like numbers (text masquerading as numbers). If you put these in a couple of empty cells in the April worksheet =count(B:B) =counta(B:B) do they match? The first counts numbers. The second counts non-empty cells. Indymanny wrote: 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 -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula will not work
Somewhere in the copy process the numbers were changed to text format.
In future rather than re-typing all the numbers, just format all to General then copy an empty cell. Select the range of "numbers" EditPaste Special(in place)AddOKEsc This coerces Excel to see them as real numbers. Gord Dibben MS Excel MVP On Tue, 15 May 2007 13:56:03 -0700, Indymanny wrote: While I was at lunch, a co-worker took a shot at the problem. All she did was re-type all the numbers in the B column on the April worksheet and then it worked. Is there a reason for this, so I know what to watch out for the next time? Again, thanks for all your help! "Dave Peterson" wrote: Put the formulas on the April worksheet, but don't use a cell in column B. If =count(B:B) returns 0, then you don't have any numbers in column B. If =counta(B:B) returns 0, then you don't have anything in that column. Indymanny wrote: Thanks, Dave for the reply. Unfortunately, nothing is working as of yet. I've double checked the names are correct ("four winds", etc.), made sure all of column B on the April document are Numbers, and tried your "count" formula - which when I did the first one, it gave me an error that it was trying to do a "circular reference", and the second one (counta) just gave me a "0". Should I be checking something else on the April sheet? "Dave Peterson" wrote: Maybe "four winds" doesn't match any cell in April's column A? Maybe the values in column B of that worksheet aren't numbers--maybe they just look like numbers (text masquerading as numbers). If you put these in a couple of empty cells in the April worksheet =count(B:B) =counta(B:B) do they match? The first counts numbers. The second counts non-empty cells. Indymanny wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
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) |