+ Reply to Thread
Results 1 to 6 of 6

SUM IF and Spinners?

Hybrid View

  1. 09-19-2007, 09:11 AM #1
    pavemar
    pavemar is offline
    Registered User
    Join Date
    04-24-2007
    Posts
    14
    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...
    Reply With QuoteRegister To Reply
  2. 09-19-2007, 09:18 AM #2
    BigBas
    BigBas is offline
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Try this and report back:

    =SUMIF(G6:G138,">"&J7,G6:G138)
    Reply With QuoteRegister To Reply
  3. 09-19-2007, 09:19 AM #3
    SamuelT
    SamuelT is offline
    Valued Forum Contributor
    Join Date
    09-23-2005
    Location
    Bristol, UK
    MS-Off Ver
    2007
    Posts
    664
    Hi there,

    Try this:

    =SUMPRODUCT((G6:G138)*(G6:G138>J7))

    HTH,

    SamuelT
    Last edited by SamuelT; 09-19-2007 at 09:21 AM.
    Reply With QuoteRegister To Reply
  4. 09-19-2007, 09:32 AM #4
    pavemar
    pavemar is offline
    Registered User
    Join Date
    04-24-2007
    Posts
    14
    BigBas,

    Check plus! thanks a bunch.

    Samuel T, thanks for the reply as well.
    Reply With QuoteRegister To Reply
  5. 09-19-2007, 09:37 AM #5
    BigBas
    BigBas is offline
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Glad I could help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1