if Sumproducts

[Srushbri]

Hi,

I have a data sheet with the following columns.
Skill Name; Assigned Chats;Transferred Chats; Conference Chats; Total Chats; Average Worked Time; Averaged Wrap Time; Average Handle Time

My hope is to sum the product of cells in Column E (Total Chats) * Column F (Average Worked time) when the Skill name is "XXX". In other words I want the SumProduct of Column E and Column F only for the rows that fit a specifications. In this case a particular (Skill Name). At first I used Vlookup but there are multiple rows in the Skill Name Column that have the same skill.

I'm having trouble formulating this. Anyone have any ideas?

thanks,
Sofia

 

[Jonmo1]

Try

=SUMPRODUCT(--(A2:A200="Skill Name"),E2:E200,F2:F200)

Skills in column A

 

[Srushbri]

Thanks Jonmo1! that worked great!

 

[Jonmo1]

You're welcome.

 

[Srushbri]

Hi, I had an additional question for this one.

Is there a way I can add multiple conditional statements? For example if I want it to find the sumproduct when the "skill name" is skillX, SkillY, or SkillZ?