Hello Everyone,
I hope you can point me in the right direction here, my understanding of Excel is very basic so I don't really even no how to research what I am after.
Problem.
I have a workbook which for the most part consists of simple adding up of numbers. On one worksheet I have some fixed figures, that I'd like to have the option of excluding from the total, I could just delete the figure, but they need to be there as a reference, I'd like to be able to experiment with different budgets by excluding and see the end result in the Gross Profit total.
I was using a formula like this =IF(D5="Y",0,E5) This then reads the figure in E5 and includes it in the totals column.
It comes undone when you attempt to calculate the totals column and then take that total away from a known sum - the Gross Profit. I can't find a way of producing a gross profit minus only included figures, of if I do, I end up with tangential results depending on the conditions of previous cell Totals.
I won't over detail the problem unless you need me to, my intuition is this must be a fairly well known and simple process, that perhaps I just need to read the right page on. Logic like this is not my strong point its probably insanely easy!
Many thanks,
Jon
Bookmarks