I'm Stuck!
Cell J7 is a value coming from a spinner control. I'd like the sum of any numbers above a certain threshhold, which is controlled by the spinner, I keep getting 0, but if I manually enter a number into the formula, then the SUMIF will work. Can I not use spinners in a formula?
=SUMIF(G6:G138,">J7",G6:G138)
Thanks!
Update:
It seems I can't use any cell value for the Greater than I'm trying to do for SUM IF...
=SUMIF(G6:G138,">J7",G6:G138) Doesn't work
=SUMIF(G6:G138,">6500",G6:G138) Does work, even where J7=6500, whether it is controlled by the spinner or not...
Try this and report back:
=SUMIF(G6:G138,">"&J7,G6:G138)
Hi there,
Try this:
=SUMPRODUCT((G6:G138)*(G6:G138>J7))
HTH,
SamuelT
Last edited by SamuelT; 09-19-2007 at 09:21 AM.
BigBas,
Check plus! thanks a bunch.
Samuel T, thanks for the reply as well.
Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks