Sum Multiple Columns only if Certain Requirements are Met

**Clemsonfan15** · 10-18-2012, 08:04 PM

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.

**jeffreybrown** · 10-18-2012, 08:08 PM

If I understand your layout correctly, try...

=SUMIF($A1:$I1,"Widgets",$B1:$J1)

**Clemsonfan15** · 10-18-2012, 08:16 PM

It worked!

Thanks so much. That was extremely helpful.

**jeffreybrown** · 10-18-2012, 08:24 PM

You are most welcome and glad it works for you. Thanks for the feedback

Note: You could also point to a cell reference if you don't want to hard code what you are looking up...

=SUMIF($A1:$I1,Q1,$B1:$J1)

Q1 = Widgets

--------------------------------------------------------------------------------------

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save