Sumifs formula with multiple criteria

[gsandy]

I have a cell with the formula below, and it works fine.
= SUMIFS($H$2:$H$65,$D$2:$D$65,"<> 3 ",$E$2:$E$65,K33)
The range to sum is ($H$2:$H$65.
The first criteria range is $D$2:$D$65.
The first criteria is any number except 3, which is a staff number.
The second criteria range is $E$2:$E$65.
The second criteria is a job number held in cell K33.

I wish to exclude a second staff number (62); how do I include an “AND” into the first criteria?

Thanks Sandy.

[JohnTopley]

Try

= SUMIFS($H$2:$H$65,$D$2:$D$65,"<> 3 ",$D$2:$D$65,"<>62 ",$E$2:$E$65,K33)

As SUMIFS works on AND criteria

[gsandy]

Thanks John, worked well, just what I wanted. Cheers Sandy