Forum

Hi Mynda I meant the likes of R1C5 for example in the respect of Row 1 Column 5.. I tend to use E1. Your concatenated cell for example is using ...

Hi Mynda, So sorry for the delay in responding.. hope your weekend was a good one. This solution works perfect, I had to adjust the RC values to matc...

Hi Mynda, Thanks for the response.. Power query is set up to return the values as currency so it should convert at that stage but it wasn't wo...

Hi Anders.. I was close, but no quite clearly.. I used the middle formula for the time being as the source files and power query would be a pa...

Hi Anders. You are a legend.. The solution you provided at the bottom =SUMPRODUCT((Invoicing[[Invoice Value]:[Invoice Value]]*Invoicing[01/01/2...