Sumif formula help to exclude seasonal employees

[Fairburne]

I currently have this formula in an excel document

=SUMIF(I3:I92,"<160")/40

But in column C3:C92 I have the values S,FT & FTE. They represent employees who are Seasonal, Full Time and Full Time Equivalencies.

I need the above formula to exclude the Seasonal employees.

So if the Value in column C is an S don't add
If the value in column C is an FT or FTE then add but only if the value in column I is less then 160

Thanks for any help on this formula

Fairburne

[Tony Valko]

Maybe this...

=SUMIFS(I3:I92,C3:C92,"<>S",I3:I92,"<160")/40

[wilcerf91]

use the sumifs function which can include multiple criteria.
You will have to double check in excel itself but I believe the format is something like...
sumifs (<sum range>, criteria range 1, criteria 1, criteria range 2, criteria 2,.... criteria range n, criteria n)

your formula would be

sum(sumifs(I3:I92 (if that's your sum range),I3:I92(if that's the criteria range),"<"160,C3:C92,"=FT"),sumifs(I3:I92 (if that's your sum range),I3:I92(if that's the criteria range),"<"160,C3:C92,"=FTE"))/4