Search
SUMIF Function _ Sum cells greater than certain value
- Ketul Patel
- Jan 31, 2017
- 1 min read
Question: I am trying to have it add up only those numbers in the column that are greater than the U24 cell. The Sumifs works if I manually enter the value of U24 but does not if I try to use the cell. I am not sure what I am doing wrong but it continues to come up with nothing.
Solution:
=SUMIF(S3:S16,">"&U24)
