General discussion

Locked

excel-calculate cells between two values

By samantha_b_titus ·
what formula do I use when e.g. I have 2 columns - column A have random numbers between 1 and 30, column B have also random numbers between 1 and 100. I want excel to search in column A for numbers greater than or equal to 5 BUT less than or equal to 20. If found it must add the numbers in column B.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by PubServant In reply to excel-calculate cells bet ...

If I understand you correctly, the following formula will work.
=IF(AND(A2>=5,A2<=20),A2+B2,)

It will add the value in column A to the value in column B if the value in column A is greater than or equal to 5 and less than and equal to 20.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums