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!
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
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)
Try this then
=COUNTIFS(S:S,">=15")
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.)
Hi Crystal
Just copy the formula in cell T2 =IF(S2<15,"under","") downwards to as many rows as you want.