Proper order of COUNTIF with multiple actions

[ddansie]

In column "B" I have a series of weights that I do a total on at the bottom. After the total, I want to get the actual weight by reducing the weight of the container. In cell "K1" I have my container weight.
My formula looks like this =COUNTIF(B2:B31,">0)*K1-B32. It gives me the correct answer, but it displays it as a -0.8. Cells "B2:B31" = 3.0 Cell "K1" = 1.1
Any help would be appreciated.

[BadlySpelledBuoy]

Hi and welcome

Are you saying each cell in B2:B31 is 3 or the total of those cells is 3? Is B32 just the sum of the above?

Might be easier to provide a solution if you could attach a sample workbook and let us know what the desired result is.

BSB

[ddansie]

Yes B32 is the sum. I have attached a copy

[BadlySpelledBuoy]

You haven't told us what the expected result is, but I'm guessing it should be 0.8 rather than -0.8.

If that's the case then try this:
=B32-COUNTIF(B2:B31,">0")*K1

BSB

[ddansie]

Yes. Thank you

[BadlySpelledBuoy]

Happy to help

BSB