Formula result not displaying in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brandon.Rutschmann@gmail.com - 13 Jul 2006 20:50 GMT

I have entered a function:

=SUM(IF(ISBLANK(F3:F39),E3:E39,0))

This is supposed sum the values in E3:E39 where the corresponding cell
in F3:F39 is blank. When I open the formula editor box, the formula
result displays correctly, but the cell only displays 0. Any ideas?
Here's some sample data:

Withhold Amt. Released
$750.00
$200.00 2/3/2006
$300.00

Total Withholding: $1,050.00 (supposed to be)

The total withholding is displaying 0 in the cell but in the formula
editor dialog box the formula result is shown as the correct 1050.

Any ideas why the formula editor would show correct amount while the
cell only shows 0?

Thanks,
Brandon

Reply to this Message

Niek Otten - 13 Jul 2006 21:00 GMT

Hi Brandon,

First thing I think of is formatting. Try formatting the cell as General, if that helps then format it the way you require.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have entered a function:
|
[quoted text clipped - 20 lines]
| Thanks,
| Brandon

Reply to this Message

Bob Phillips - 13 Jul 2006 21:04 GMT

It is an array formula, so you need to array enter it, that is commit it
with Ctrl-Shift-Enter together, rather than just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

> I have entered a function:
>
[quoted text clipped - 20 lines]
> Thanks,
> Brandon

Reply to this Message

Brandon.Rutschmann@gmail.com - 13 Jul 2006 21:30 GMT

PERFECT Bob! That was it! THANK YOU!!!

> It is an array formula, so you need to array enter it, that is commit it
> with Ctrl-Shift-Enter together, rather than just Enter.
[quoted text clipped - 31 lines]
> > Thanks,
> > Brandon

Reply to this Message