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