top of page

SUMIF Function _ Sum cells greater than certain value

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)


Featured Posts
Recent Posts
bottom of page