Home

How to get excel to ignore data....

%3CLINGO-SUB%20id%3D%22lingo-sub-559978%22%20slang%3D%22en-US%22%3EHow%20to%20get%20excel%20to%20ignore%20data....%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-559978%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20tracking%20spreadsheet%20that%20tracks%20expenses%20for%20each%20month%20in%20certain%20categories.%26nbsp%3B%20Some%20months%2C%20I%20don't%20have%20any%20expense%20for%20a%20category.%20The%20formulas%20I%20have%20created%20are%20set%20up%20to%20pull%20from%20other%20spreadsheets%20that%20are%20set%20up%20so%20that%20when%20I%20put%20in%20the%20current%20data%2C%20each%20month%20will%20update%20based%20on%20the%20dates%20when%20the%20expenses%20accrued.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20for%20one%20category%20if%20I%20don't%20the%20expense%20until%20Dec%2C%20but%20it%20was%20posted%20in%20July%2C%20my%20spreadsheet%20will%20update%20the%20July%20numbers%20to%20reflect%20it.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20need%20to%20keep%20track%20of%20what%20my%20projections%20for%20the%20year%20are.%26nbsp%3B%20So%20if%20I%20don't%20have%20any%20expense%20in%20July%20for%20a%20category%2C%20and%20it's%20Jan%2C%20I%20need%20to%20figure%20out%20what%20my%20possible%20expense%20would%20be%20if%20I%20keep%20my%20current%20average%20for%20the%20next%206%20months%20(until%20the%20end%20of%20June).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20figure%20out%20how%20to%20get%20excel%20to%20ignore%20the%20zeros%20in%20the%20months%20that%20haven't%20happened%2C%20but%20include%20the%20zeros%20for%20the%20months%20that%20have%20happened%2C%20to%20create%20a%20projection%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-559978%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560309%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20excel%20to%20ignore%20data....%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560309%22%20slang%3D%22en-US%22%3EPlease%20attach%20your%20sample%20file%20so%20I%20can%20visualize%20what%20you%20mean.%3C%2FLINGO-BODY%3E
drusilla77
Occasional Visitor

I have created a tracking spreadsheet that tracks expenses for each month in certain categories.  Some months, I don't have any expense for a category. The formulas I have created are set up to pull from other spreadsheets that are set up so that when I put in the current data, each month will update based on the dates when the expenses accrued. 

 

So for one category if I don't the expense until Dec, but it was posted in July, my spreadsheet will update the July numbers to reflect it.  

 

But I need to keep track of what my projections for the year are.  So if I don't have any expense in July for a category, and it's Jan, I need to figure out what my possible expense would be if I keep my current average for the next 6 months (until the end of June). 

 

I can't figure out how to get excel to ignore the zeros in the months that haven't happened, but include the zeros for the months that have happened, to create a projection formula. 

 

 

1 Reply
Please attach your sample file so I can visualize what you mean.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies