Example TEXT and SUMIFS

Hi – today I would like to detail how you can use the ‘TEXT’ function within a ‘SUMIFS’ function. 

 

 A 'TEXT / SUMIFS' combination can be very useful for users who are handling large amounts of transactional data that is date specific but needs to be grouped.

 

Below is a very basic example of how you can easily summarise data by month. By adding a 'Period' column to the raw data a SUMIFS function can then be utilised when summarising the raw data. 

Please feel free to download the example above.  I hope you find this post useful. 

Darren