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 1864 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


1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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))
0