I am using =SUMIF(D4:D1115,"<700")
What I want to do is have the value 700 in another cell.
I tried =SUMIF(D4:D1115,"<B5") and put 700 in B5 but it returns zero.
Also tried a lot of other variations/syntax and Google hasn't been helpful
Thanks in advance