Formula result not displaying in cell

B

Brandon.Rutschmann

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
 
N

Niek Otten

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




|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
|
 
B

Bob Phillips

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)
 
B

Brandon.Rutschmann

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


Bob said:
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top