Skip to content
Julia the PC GP

Julia the PC GP

Individual support and training for your home and small business computing needs

  • Welcome
  • Sales
    • Buy the IT items you need from Julia the PC GP
  • Support
    • Desktop Computers
    • Laptops support and training
    • Mobile phones – Smartphones (Android or iOS) – but also regular mobiles
    • Safe browsing directory – last checked by Julia on 5th September 2023
  • Training
    • Resources
      • Jargon Buster – last updated 9th September 2023
      • Training videos
  • Tips & Advice
    • Desktop computing tips
    • Mobile computing tips – Laptops, tablets (incl iPads) &mobiles (including smartphones)
    • General Tech Tips
    • Articles
    • Handy keyboard shortcuts – Control key
    • Handy keyboard shortcuts using the Windows key
    • More handy keyboard shortcuts
    • Tips – by category
  • About Julia
    • Julia Info
    • Community
    • Testimonials
  • Enquire now
  • Feedback
  • Toggle search form
Image showing the dialogue box which comes up when you choose the Function button after typing in SUMIF

Managing your money in Excel (Cashflow)

Posted on 3 August 202217 April 2023 By JuliaEEvans No Comments on Managing your money in Excel (Cashflow)

Did you know that you can use Excel’s SUMIF feature to automatically generate a Cashflow spreadsheet?

The screen below shows the one I use for monitoring my business income and expenditure across the year:-

Cashflow spreadsheet with the highlight in cell for IT Income (New client) for April - ready to use the SUMIF feature to pull the figure from another cell (or even another file, and update if it changes!

The 3 fields (Range, Criteria and Sum_range) enable Excel to constantly monitor them for any changes.

This means that I change a figure in my worksheet for April and/or June (for example) the Cashflow will reflect this immediately.

I’ve been using this kind of feature for years in my work as an Accounts Admin Assistant, to replace manual spreadsheets which needed constant checking!

Need help from Julia now?
Sign up for tips
Microsoft, MS Office Tags:cashflow, cell, condition, criteria, excel, function, microsoft, spreadsheet, SUMIF, worksheet

Post navigation

Previous Post: Calendar reminders by email
Next Post: Viewing all open windows at a glance

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Thank you for visiting - may I have your feedback? Julia

  • Office tip for your files
  • Bookmark your favourite website pages
  • PowerPoint – Slide Sorter view
  • Managing your Excel tabs
  • Cloud storage for FREE !
  • Accessibility
  • Accessories
  • Apple
  • Children
  • Email
  • Gmail
  • Internet
  • iPad
  • iPhone
  • Microsoft
  • Mobile devices
  • MS Office
  • Online
  • Security
  • Shortcut keys
  • Smartphones
  • Smartphones
  • Uncategorized
  • Windows 10
  • Windows 11
  • Windows 8
  • Zoom
September 2023
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  
« Aug    

Archives

  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022

Copyright © September 2023 Julia the PC GP.

Powered by PressBook WordPress theme