Lookup to sum totals

[kac1125]

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

 

[kac1125]

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

 

[NARAYANAN]

USE SUMIFS FORMULA

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

 

[kac1125]

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!