# Lookup to sum totals

#### kac1125

##### New Member
Hello,

Looking for a sum/vlookup formula to sum up the total values for a certain criteria. For example I am looking to sum up Days for a name I input in cell D2 so lets say D2 is Joe, I want E2 to read 9.5. Any help will be appreciates. THanks in advance!
 Name qty Days Joe 50 7.5 John 40 2 Rich 30 1 John 20 2 John 15 3 Rich 10 1 Dan 40 2 Tom 40 2 Joe 30 2

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

#### kac1125

##### New Member
Forgot to mention the names start in A2 qty B2 Days in C2

#### NARAYANAN

##### New Member
USE SUMIFS FORMULA

ENTER =+SUMIFS(C2:C10,A2:A10,D2) IN E2 AND INPUT JOE IN D2 TO GET YOUR RESULT

#### kac1125

##### New Member
USE SUMIFS FORMULA

ENTER =+SUMIFS(C2:C10,A2:A10,D2) IN E2 AND INPUT JOE IN D2 TO GET YOUR RESULT
Thanks! this worked! one more question. what if I am using a slicer? It seems to pull the full sum instead of the filtered values. Please let me know if you have any ideas.

Thanks again!