Sumif evaluating incorrectly

J

JG Scott

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.
 
T

Trevor Shuttleworth

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

(too many quotes)

Regards

Trevor
 
Top