Combining SUMIF and Subtotal for a single column of numbers

[mosesthetank]

I have a column of numbers with several subtotals. At the bottom of the column I want to use a SUMIF to total the column but ignore the Subtotals and all negative numbers. I attached an example file with the desired result.

Thanks!

[Jonmo1]

Try
=SUMIFS(B1:B14,B1:B14,">0",A1:A14,"<>Ttl")

[AZ-XL]

Alternative solution
=SUBTOTAL(9,B1:B14)-SUMIF(B1:B14,"<0")

[mosesthetank]

Jonmo1 and AZ-XL. Both of your solutions work. I went with AZ-XLs because the text in column A is unreliable. Thanks to both of you!

[AZ-XL]

You are welcome. Thanx for feedback

[daddylonglegs]

=SUBTOTAL(9,B1:B14)-SUMIF(B1:B14,"<0")

This may not work if any of the subtotals are negative