Sumif Excel Function - multiple conditions

[Closed]
Report
Posts
1
Registration date
Friday September 14, 2012
Status
Member
Last seen
September 14, 2012
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
=SUMPRODUCT(0+($A$1:$A$100="Technician"),0+($B$1:$B$100))+SUMPRODUCT(0+($A$1:$A$100="engineer"),($B$1:$B$100))