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

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]OK?[/TD]
[TD]Item[/TD]
[TD]QTY[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]OK[/TD]
[TD]A[/TD]
[TD]100[/TD]
[TD]=SUMIFS(K:K,F:F,F2)[/TD]
[/TR]
[TR]
[TD]OK[/TD]
[TD]A[/TD]
[TD]100[/TD]
[TD]=SUMIFS(K:K,F:F,F2)[/TD]
[/TR]
[TR]
[TD]NOT OK[/TD]
[TD]A[/TD]
[TD]100[/TD]
[TD]=SUMIFS(K:K,F:F,F2)[/TD]
[/TR]
[TR]
[TD]OK[/TD]
[TD]A[/TD]
[TD]100[/TD]
[TD]=SUMIFS(K:K,F:F,F2)[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.