Forum Discussion
How to find an amount by adding other amounts
Hello, I switched from xp to window 10 and from Office 2003 to 2016. I have a workbook with budget sheets. They always worked perfectly but now I have a sheet that do not balance.
A - I divided my expenses by category (ex: house, food, car, etc.);
B - I list under its proper category (A) the expense in a sub-category (insurance, taxes, repair, etc.);
C - Under each category (A) I manually add in a cell all expenses of all subcategories. Then I add the expenses of all categories in one cell at the bottom.
D - Also I add all expenses pertaining to a month.
Now, the total at D does not correspond to the total of C and I can not find the problem which is a difference of (29.06) in the bottom (D) of the file.
I would like help on how to search the sheet and find the various amounts that may amount to that 29.06 + or minus 1 cent. Your help would be appreciate.
- Hi Cdn
I might suggest uploading a sample file for the community to review. It's challenging to diagnose a problem without seeing it in action (speaking for myself anyway).
Good luck!
Cheers
Damien - You don't expect me to send all my personal financial data, do you? May be I could reformulate. I need to be able to have Excel to go through a list of amount and to add different amounts so to find 29.06 plus or minus 1 penny. There must be a solution to this 29.06. Thank you
Hi Cdn
Not at all would anyone expect you to upload your financial data, that's why I suggested a sample file. For example, it could have one line of faked data to demo the issue with the formula calculations.
In saying that if anyone else on the forum can visualise what you are saying and has an answer, that would work too.
I tend to need to see something to understand it.
Either option you choose, best wishes for your Excel issue!
Cheers
Damien
