Log In
Register
Home
Active Member
March 1, 2019
Offline
Hi there. Hoping you can help me find a quick solution to my problem. Please see my attachment.
What I am needing is an easily visible way to be alerted when column "S" is less than 15. If that happens, I need it to say "under". Also, can I make it put "under" in red font?
2) The other thing I would like for it to do is to calculate the total amount of cells in column "S" that are 15 and over. How can I do that?
Thanks!
VIP
Trusted Members
June 25, 2016
Offline
Hi Crystal
Q1) You can try =IF(S2<15,"under","") to compare cell S2. You can just highlight the cell with the formula in red font.
Q2) Try =SUMIFS(S:S,S:S,">=15")
Hope this helps.
Sunny
Active Member
March 1, 2019
Offline
Hi Sunny, thanks for trying to help me with this. I'm working on Q2) and it's almost the formula I need.
I don't think I explained it exactly right. I don't need it to calculate the "sum" of the cells in column "S" that are ">=15". I need to tell me, out of the 26 cells that are in that column, how many of them (the total number) are ">=15". Can you help me with that, I hope? :o)
VIP
Trusted Members
June 25, 2016
Offline
Try this then
=COUNTIFS(S:S,">=15")
Active Member
March 1, 2019
Offline
I was able to get the formula to work for question 2 thanks to your help!
Going back to question 1. It's almost there, but the problem is that it will only give me the alert "under" in column T in cell 2 and only if I specify a certain cell on its own. I'm inserting the formula in column T cell 2. Am I doing that part correctly?
What I need it to do is say "under" in column T for each individual cell number that is under the number 15 in column S. (I hope that makes sense.)
1 Guest(s)
