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

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.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel




wrote in message oups.com...
|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
|

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)

wrote in message
oups.com...
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

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


Bob Phillips wrote:
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)

wrote in message
oups.com...
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