Previous Topic Next Topic

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

Answer 1 / 1
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))
0

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses