Forum

Thank you Mynda for confirming my understanding... was just hoping that I had missed something... 🙂

Mynda - your above-suggested SUMPRODUCT(xxxx) formula works PERFECTLY! And even better - I learned so much utility by breaking down the formula into ...

Mynda - Thank you for your kind reply - I will try the formula you suggest for the conditional tallies and add Power Query to my learning "to do" list...

Hi Mynda - So the AGGREGATE function is pretty cool - but unless I'm missing something - it doesn't solve my problem. I'm using COUNTIF to sum th...

Mynda - THANK YOU! I was not aware of the AGGREGATE function in my work to date (don't know what I don't know) and that looks like exactly what I nee...