7 January 2013

First client

31 December 2019

Last software update

< 2 hours

Support response

StatementReader is used by forensic accountants, bookkeepers, insolvency investigators, solicitors, auditors and business review professionals to stop wasting time and talent converting bank statements into Excel

This website uses cookies to enhance the user experience.  Click here for our cookie statement and here for our privacy policy.

All Rights Reserved 2012-2020 Suave Software Limited. London, England, United Kingdom. Email Us

  • LinkedIn Social Icon
  • Twitter Social Icon

Single condition summary using SUMIF

SUMIF can be used to summarise many transactions for a single condition. Here are some examples:

- Show the total credits where the date is after 1 January 2013

- Show the total credits where the balance was overdrawn

- Show the total credits where the description includes the word 'HMRC'

Although this may seem useful at first, you will quickly want to summarise data based on more than one condition (for example, what's the total credits for the period between 1 January 2013 and 31 December 2013). To achieve this, you'll need to use the SUMPRODUCT formula.

#Excel #Formula #All