outgoings

  1. D

    Is SUMIF the answer

    Morning, I am trying to create a formula that will minus F51 by B59 if D59 =P, i have tried formula =SUMIF(D59,"P",F51-B59) but this creates an error. I am thinking SUMIF is not the correct formula I need to use as I am trying to subtract. Can any kind person please help me resolve this please...
  2. P

    Excel 2010 - Linked Workbooks no longer opening properly

    Using Excel 2010 on Windows 10 (V 1803 (Build 17134.112) This afternoon I was working on 3 Workbooks, Summary, Income and Outgoings. Both Income and Outgoings files are linked to the Summary ie input new figures on Income or Outgoings and the Summary immediately shows and calculates these new...
  3. G

    bi-weekly occurrence within given range

    Hi, I am setting up a family budget planner, and want to list the fixed outgoings (Description / Amount / Frequency [Monthly / Weekly / Bi-Weekly] / First Date Taken. The variable outgoings, I want to list in a separate table (Date / Description / Amount). The problem I am having is as...
    • Giofan
    • Thread
    • budget date calculation frequency list outgoings
    • Replies: 1
    • Forum: Excel Questions
  4. O

    Changing which cells are summed based on date

    Hi, I hope someone can help me! I have a workbook to keep track of my finances - I've set one sheet to total up my regular outgoings, and take it off what I earned that particular month. I have another that I put all my purchases in to, which tallies up how much I've spent in a particular...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top