+ Reply to Thread
Results 1 to 3 of 3

Sumif evaluating incorrectly

  1. #1
    JG Scott
    Guest

    Sumif evaluating incorrectly

    I have a sheet with the following formula in cell F2:
    =SUMIF($F$60:$F$70,"<>""",$E$60:$E$70) This forumla returns 39,500,
    even though there is nothing in E60:E70. I've checked, and even
    deleted the range a couple of times. It "thinks" there is something in
    E60:E70, but there isn't. Anyone have an idea why this could happen
    and how to fix it??

    In case it matters, this is in a workbook that used to be 2 separate
    workbooks, each with lots of VBA.

    Thanks.


  2. #2
    Trevor Shuttleworth
    Guest

    Re: Sumif evaluating incorrectly

    =SUMIF($F$60:$F$70,"<>",$E$60:$E$70)

    (too many quotes)

    Regards

    Trevor


    "JG Scott" <jgscott3@bellsouth.net> wrote in message
    news:1141340226.631457.307650@e56g2000cwe.googlegroups.com...
    >I have a sheet with the following formula in cell F2:
    > =SUMIF($F$60:$F$70,"<>""",$E$60:$E$70) This forumla returns 39,500,
    > even though there is nothing in E60:E70. I've checked, and even
    > deleted the range a couple of times. It "thinks" there is something in
    > E60:E70, but there isn't. Anyone have an idea why this could happen
    > and how to fix it??
    >
    > In case it matters, this is in a workbook that used to be 2 separate
    > workbooks, each with lots of VBA.
    >
    > Thanks.
    >




  3. #3
    JG Scott
    Guest

    Re: Sumif evaluating incorrectly

    Thanks, Trevor!


+ 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