One of my friend at work asked me Multiple column value addition based on criteria with large data, below is essence of data in short.
he wanted a formula to give the sum of values of a bike sold at two different location, conditions being dynamic(bike,location). like Yamaha sold in Agra and Mumbai with bike and location being dynamic.
I could come up with these two options
1) sumproduct formula
in two different cell write sumproduct formula and the add them
2) Vlookup array formula
single step vlookup array formula (not really single step)
Solution file is link is below