Excel question

[tres]

Dear all,

I have a nice simple "SUMIF"

=SUMIF($B$4:$B$68,$E72,G$4:G$68)

B: Department they work
E72 = "Kitchen"
G: Hours they work



So, add up all the hours for everyone that works in the kitchen

But how do i do it, so it does the same BUT

add up all hours if they work in the kitchen AND another cell states they're permanent?


Can you do an AND function within the SUMIF's "criteria" bit?

Thank you

 

[tres]

Sorted it!

For all future "nested sumif" searches...

The key is using a SUMPRODUCT

=SUMPRODUCT(($B$2:$B$68=$E101)*($F$2:$F$68="P"),G$2:G$68)

First criteria (ie. Department = "kitchen")
Second criteria (ie. Contract = "Permanent")
Range to sum