Count Loss and Profit

Richard A

Hi All,

I have a column that I want to gather information from on a seperate sheet - I would like to add all the Negative numbers and the Positive number seperately, so I can then determine Lossess against Profits, , I've tried =COUNTIF({Tooling Quotes - Provisional Vs Actual Range 1} < 0)

Thanks in advance

Paul Newcome

Your formula is missing a comma between the {Range} and criteria.

SoS | Dan Palenchar

Hello @Richard A

Try using:

=COUNTIF({Tooling Quotes - Provisional Vs Actual Range 1} , < 0)

If that doesn't work try

=COUNTIF({Tooling Quotes - Provisional Vs Actual Range 1} , @cell < 0)

Richard A

Thank you for the responses - the other thing I realised I need to do was SUMIF, not COUNTIF.

Thanks again

Paul Newcome

Happy to help. 👍️