Multiple condition Count and Sum IF


In Excel from 2007 onwards, there are functions to do this (countifs and sumifs) but there has been a way to do it long before – and I still prefer it to the newer way (in much the same way as I prefer using the & sign to using the concatenate function!). By using a logical test and a mathematical trick, you can get SumProduct to do the job for you. I’ve done a quick video at YouTube explanation which explains it!

Leave a Reply