swjtx99
asked on
Sumif value greater than value in another cell
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
swjtx99
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
swjtx99
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Ken,
Works great!
Regards,
swjtx99
Works great!
Regards,
swjtx99
greater than is >
Open in new window
Regards