After a few weeks of searching on the internet and especially YouTube så fann jag otroligt många klipp om excel. There are a bunch of real fanatics out there but what I had expected?

Anyway, I found a formula, budget files that will produce the original budget, outstanding expenses, final cost estimates and the monitoring of these.

Formula was SUMIF which proved to be extremely useful. Hard to explain here in detail how to do it depends on how you set up your budgetfil but I recommend going into Excel King website you will get lots of cruel the tricks of Excel that suddenly makes you King of your work which can be a pain when all will come to you and ask for advice all the time…or it will not be difficult.

Formelns argument

=SUMMA.OM (area;conditions;Total area)

• Area: Cellområdet som vi ska leta efter villkoret i
• Conditions: Själva villkoret. Can be a such (t ex 8), in Evaluation (t ex >7) or text (such as "Spoons").
• Summary Area: Cellområdet som vi ska summera

Important: Remember that "Area"And"Summary Area” should include the same lines (but different columns of course).

Excel owns and yes…it's a little crazy to get involved with it during the holiday.

ASu