Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
Currency to Text | Excel Worksheet Functions | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions |