LinkBack URL
About LinkBacks
IF I have a column of 1000 values, and 600 of them are positive. The rest are negative or 0, then the result should be 60%. What formula can I use to calculate this for every column in my worksheet?
IF I have a column of 1000 values, and 600 of them are positive. The rest are negative or 0, then the result should be 60%. What formula can I use to calculate this for every column in my worksheet?
Try:
=COUNTIF(A:A,">"&0)/COUNT(A:A)
Format as percentage.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
so you are just counting the values > 0
and you know its a 1000 rows
=COUNTIF(A2:A1001,">"&0)/1000
and copy for all the other columns you want to calculate
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I think in both solutions just ">0" could be used as criteria, so:
Formula:
Please Login or Register to view this content.
or
Formula:Please Login or Register to view this content.
If the value to be compared is constant we could hardcode it into criterion. Of course if we would like to use content of some cell concatenation operator shall be used, like
Formula:Please Login or Register to view this content.
Best Regards,
Kaper
Thanks everybody!
A1:M1 as follows: -0.5, -1, -1, 0.5, 1, 2, -1, -2, -0.6, 1, 3, -1, -1. Plz count the sum of event if at least two consecutive numbers less than or equal to -1 and end when greater than or equal to 0 (considered as an event need to be counted, and then calculation the sum for each events
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks