Hi everyone.

This might be an easy formula, but I can not figure out how to do it.

I have the following structure: Column A=Data Validation (Drop down list) Column B=Numerical value

This series repeats five times through Column J. There are five drop down choices.

If I then want to set up Columns K-O as sums of each drop down, how do I get Excel to look through Columns A-J and pull that data?

For example if Column A displayed Widgets and column B had a value of 5, but then column C displayed Toys and column D had a value of 10. column E displayed Widgets again and column F had a value of 15.

How would I get Column K to display the sum of only the Widgets?

Is this even possible?

Thanks.