top of page

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.

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page