Sumif Excel Function - multiple conditions

Closed
michaerd Posts 1 Registration date Friday 14 September 2012 Status Member Last seen 14 September 2012 - 14 Sep 2012 à 19:22
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 14 Sep 2012 à 23:53
Hello,

I have a list of job titles in column A with their corresponding headcount amount in column B. Is there a sumif formula that will sum the totals in column B if column A contains both "Technician" and "Engineer". Looking for a formula that will total to 15. So if the column A range contains "Technician" & "Engineer" then add their corresponding value in column B.

Ex: A B
Technician 10
Engineer 5


Related:

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
14 Sep 2012 à 23:53
=SUMPRODUCT(0+($A$1:$A$100="Technician"),0+($B$1:$B$100))+SUMPRODUCT(0+($A$1:$A$100="engineer"),($B$1:$B$100))