Forum Discussion
Solved
Sumifs with Custom Excel Data type from power Query and using dot notation
I am just experimenting with Custom Excel Data Types and dot notation. I was trying to come up with a equivalent to sumifs without any luck. In my example I use fake data and I am trying to summ...
I found a solution by googling. AI gave me the answer, but I could not find the original source(s)
Use Sumproduct or sum & filter. If someone can help me identify the original source I will give them credit.
https://www.google.com/search?q=sumifs+using+custom+data+type&rlz=1C1GCEB_enUS1066US1066&oq=sumifs+using+custom+data+type&gs_lcrp=EgZjaHJvbWUqBggAEEUYOzIGCAAQRRg7MgYIARBFGDwyBggCEEUYPDIGCAMQRRg80gEIMTgwOGowajeoAgCwAgA&sourceid=chrome&ie=UTF-8
Hi
Here is a drop box link to my spreadsheet => Unfortunately there's no link in your initial post - Not necessarily your mistake as this site currently (& randomly ???) drops ex. file attachments and hyperlinks are bugging as well
Could you try again please?