Sum if Yes or No with specific criteria

[accoexcel]

I have a column for Yes/No and columns for contacts, VM, and abandon. If yes, I need to sum all three columns. If no, I need to sum contacts and abandons and I cannot figure what the best method to complete the formula should be. I've tried SUMIF variations and cannot get anything to work in my favor. My google searches have come null as I'm just not getting the right terms. Any help is greatly appreciated!

 

[kweaver]

Welcome to Mr. Excel. It would greatly help if you provided a few examples of your worksheet using XL2BB.

 

[accoexcel]

Hope I did this correctly. Essentially if C is yes, I need to sum D,E,&F. If no, then just D&F

Date	Customer	Is Voicemail Captured?	Contacts Made	Voicemails (left message)	Abandoned (did not reach)	Contacts Test	Total Contacts Made	VM+Contact Success Rate	Contact Made Rate	AHT (Minutes)	ASA (Minutes)	Avg Abandon Time	Outreach Gap Target	Status
8/25/2020		Yes	13	67	13		93	86%	]/[@[Total Contacts Made]]]14%	3:11	0:09	0:17	4000	On Hold
8/26/2020		Yes	31	92	20		143	86%	]/[@[Total Contacts Made]]]22%	2:25	0:08	0:32	4000	On Hold
8/27/2020		Yes	80	163	23		266	91%	]/[@[Total Contacts Made]]]30%	2:12	0:08	0:16	4000	On Hold
8/28/2020		Yes	60	189	36		285	87%	]/[@[Total Contacts Made]]]21%	2:39	0:08	0:21	4000	On Hold
9/1/2020		Yes	98	312	49		459	89%	]/[@[Total Contacts Made]]]21%	2:17	0:07	0:11	4000	On Hold
9/2/2020		Yes	117	363	54		534	90%	]/[@[Total Contacts Made]]]22%	2:59	0:07	0:08	4000	On Hold

 

[kweaver]

Try: =if("Yes"=C2,sum(D2:F2),sum(D2,F2))
and fill down.

 

[Fluff]

Another option
=SUM(D2,F2,E2*(C2="Yes"))

 

[accoexcel]

Thanks all. I was able to sort out my mistakes with your help!

 

[Fluff]

Glad we could help & thanks for the feedback.