EliseB✭

Thank you Andree! That helps a lot - I am new to sheet summary fields so had no idea @row references would not work. Really appreciate the help thanks very much. Elise

Thank you so much Kelly, I had no idea about the left condition, that's a game changer! I tried both the middle and the bottom option and they both work perfectly! Thank you that has saved me hours of trouble and anxiety. Really appreciate it, Elise

Hi Kelly, Thank you but no unfortunately that doesn't work for me, it comes up as #Unparseable, I assume that is because the values are H5, H4, H3 etc rather than H alone? I don't understand the need for the LEFT when referencing the Priority rating column either? I should add that there will be no additional options being…

Thanks Paul, that is great. Appreciate it! Elise

Thanks Genevieve, Due to the volume of reports and dashboards and the tight timeline we had I decided to go a different way and utilised pie charts and columns to split the data using the pre- existing reports with the view to refine this down the track when there is more time! Thanks for these details I will save it and…

I've realised I probably need a kind of lookup and sum function, lookup the value in the customer journey column and then return the sum of the total high impacts in all sheets matching the high/customer journey arguments. Has anyone got any advice ?