# Sumif Excel Function - multiple conditions

Closed
michaerd Posts 1 Registration date Friday September 14, 2012 Status Member Last seen September 14, 2012 - Sep 14, 2012 at 07:22 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 14, 2012 at 11:53 PM
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 June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 14, 2012 at 11:53 PM
=SUMPRODUCT(0+(\$A\$1:\$A\$100="Technician"),0+(\$B\$1:\$B\$100))+SUMPRODUCT(0+(\$A\$1:\$A\$100="engineer"),(\$B\$1:\$B\$100))