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.

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

(too many quotes)

Regards

Trevor


"JG Scott" <[email protected]> wrote in message
news:[email protected]...
>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.
>

Thanks, Trevor!