# Get instant live expert help on sumif less than

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need to have a formula that will determine if a contract is due to expire in less than 30 days then the cell will say "less than 30 days" and will be coloured red, if less than 60 days then says "less than 60 days" and coloured amber and if less than 90 days then says "less than 90 days" and coloured Green
Solved by E. S. in 14 mins
What is the formula for greater than or less than on excel?
Solved by T. F. in 21 mins
if i have criteria that needs to be met to create a specific color if e2 is less than or equal to 70, green or if e2 is less than or equal to 90, blue or if e2 is greater than 90 but f2 is is less than equal to 110, blue, or if e2 is greater than 90 but f2 is is less than equal to 115, yellow, or if e2 is greater than 90 but f2 is is less than equal to 120, pink, or if e2 is greater than 90 and if f2 is greater than 120, red
Solved by K. H. in 24 mins
I need column D and E to be green if less than column O and Red if more than column O. I also need column F green if less than column P and red if more than column P.
Solved by E. C. in 23 mins
6. On the Sales Sheet (It is blank). Create a lookup table. In the first column there should be the values to setup the different categories based on Total Sales. Anything less than \$3000 is considered Low Sales. Anything greater than \$3000 but less than \$7000 is considered OK Sales. Anything greater than \$7000 but less than \$11000 is considered Average Sales. Anything greater than \$11000 but less than \$15000 is considered Above Average Sales. Anything Greater than \$15000 is considered Excellent Sales.
Solved by A. S. in 26 mins