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.