+ Reply to Thread
Results 1 to 7 of 7

SUMIF not adding

Hybrid View

  1. #1
    Registered User
    Join Date
    05-10-2012
    Location
    Olathe, KS
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: SUMIF not adding

    It worked! The fx button/wizard automatically placed the quotes, so I'm not sure if it's working correctly or I did something wrong. Thanks for the help.

    Quote Originally Posted by jeffreybrown View Post
    How about

    =SUMIF(D2:D13,">="&$D$2*0.0004)

    You were almost there, just a quote out of place with the addition of an ampersand.

  2. #2
    Registered User
    Join Date
    05-10-2012
    Location
    Olathe, KS
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: SUMIF not adding

    What does the "&" do?

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1