However, what I want to do is the result of the above I also want the net value of the text result. For example if the first sorted value says 'Digital' I then want to have the sum of the net value of 'Digital'. Also these are dynamic KPIs in a text box, so I cannot do a simple 'if match' function.
Thank you so much! This is exactly what I wanted. 😀
Before I mark your response as the solution, is there any way to have 'Net value' formatted as currency as it displays as just a number and I would prefer it formatted if possible. I tired adding in ,'£#,##0', '.',',') but it doesn't seem to fit in. Many thanks!!!