Forum Discussion

Cdn Hermit's avatar
Cdn Hermit
Copper Contributor
Jul 26, 2018

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.

 

 

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    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
  • Cdn Hermit's avatar
    Cdn Hermit
    Copper Contributor
    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
    • Damien_Rosario's avatar
      Damien_Rosario
      Silver Contributor

      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

Resources