auto sum in excel of results from IF function

Microsoft Excel 2003 (full product)
August 26, 2010 at 11:26:56
Specs: Windows XP
I have a workbook with two worksheets (used for simple production scheduling and inventory), one were you record product receipts and post consumption, the second where you indicate how much of your inventory you are consuming (production requirements) for the "week of". In the production requirements sheet you indicate the week you are running production and amount to be consumed that week. In the consumption worksheet I use an IF statement to look at the date from the production sheet and compare it to dates (all of these are Mondays) in the consumption sheet, if the dates match it takes the amount to be consumed from the production worksheet and enters it into the consumption cell - if the dates do not match it returns the amount that is in the cell, either 0 or a number from a previous entry. Then I sum the consumption entries for each week (52 total), subtract them from the receipts and beginning inventory and have an running inventory number. Everything was working fine (just built the thing), closed it and when I reopened it the auto sum is not working, returning zeros. I reduced the number of cells summed; I added the cells separately; nothing is working. It now appears to be paying attention to the week entered, I can get that week to return but as soon as I add it to another week I get zero. Is there any way to get it to view the cells with the IF function as values only? thanks.

See More: auto sum in excel of results from IF function

Report •

August 26, 2010 at 11:50:55
re: "when I reopened it the auto sum is not working"

I'm not sure what you mean by "auto sum".

In Excel, AutoSum is represented as the Greek Capital letter Sigma Σ in the toolbar. When you select a cell and click the AutoSum symbol, it looks for numbers above the cell (or to the left if there are no numbers above it) and SUMs them.

While you've done a fine job of describing how you use your spreadsheet, keep in mind that we can't see it from where we're sitting.

Perhaps it would help if you included the formula that you are using (the one that is not working) and the basic lay-out of the spreadsheet. i.e. what's in the cells that the formula references, etc.

Report •
Related Solutions

Ask Question