Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi can I get the negative cells counted in a separate cell (V7)?
Yes I am trying it out in a few minutes expect feedback in half an hour
I am sorry I cant get it to work for me, probably wrong typing when changing the parameters can you pls check for me
File ID on 466876 on http://www.wikisend.com
Hi ThereIt is very straight forward what you require, you have just been given the wrong formulas.
I have done this for you, and in your Spreadsheet I have done the following
Count of the amount of Negative Cells
Sum of the amount of Negative Values
Count of the amount of Positive Cells
Sum of the amount of Positive Values
The file you can download from wikisend under filer ID 518204
You will see them there.If you have any difficulties at all, please do not hesitate to let me know so I can assist you further
Hi again, thanks for your assistance. I have tried what you gave me earlier and that worked fine - BUT - going back to my initial question, if I filter in this database as in column C, I would like to see partial results showing the filtered cells only, how do I put that in the formula?