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

Recent Posts

See All

Frequently Asked Questions, by phone

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to us (or upload it using the 'File' menu within StatementReader) a

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm