HOW do i combine sumfs and if functions to negate a data set within cells?

[JRomaine1320]

So, i want to get totals using sumif but if i want to exclude a set of cells from totals based on criteria, how do i do that?
Ive got the sumifs total, but i want to exclude "not ok" from the total.
Most likely a combination of sumifs & if, but i cant get it.
Please see table below

OK?	Item	QTY	Total
OK	A	100	=SUMIFS(K:K,F:F,F2)
OK	A	100	=SUMIFS(K:K,F:F,F2)
NOT OK	A	100	=SUMIFS(K:K,F:F,F2)
OK	A	100	=SUMIFS(K:K,F:F,F2)

<tbody>
</tbody>

 

[JRomaine1320]

columns
OK =D
Item = F
QTY = K

 

[AhoyNC]

Maybe:

[TABLE="width: 258"]
<tbody>[TR]
[TD="width: 258"]SUMIFS(K:K,F:F,F2,D:D,"<>NOT OK")
[/TD]
[/TR]
</tbody>[/TABLE]

 

[JRomaine1320]

Worked Like a charm! thanks so much!

 

[AhoyNC]

You're welcome. Thanks for the feedback.