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)
>
> <Brandon.Rutschmann@gmail.com> wrote in message
> news:1152820203.356566.279090@i42g2000cwa.googlegroups.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
> >