Multiple column value addition based on criteria

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.

Image

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)

Image

Solution file is link is below

https://docs.google.com/file/d/0B2FLZ9YjqpJTb2M0REZUYzlhYjg/edit?usp=sharing

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s