| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula results not displaying
I have an IF formula which will display the proper result in the functional
arguments pop-up but not within the cell itself. I thought this was a simple format error on the cell but I verified it is set as a number but still displays "0" as the result. Formula is: =SUM(IF(('Resource Details'!$D$3:$D$295="XYZ")*('Resource Details'!$F$3:$F$295="ABC")*('Resource Details'!$H$3:$H$295="123"),('Resource Details'!$M$3:$M$295))) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula results not displaying
{=SUM(IF(('Resource Details'!$D$3:$D$295="XYZ")*('Resource
Details'!$F$3:$F$295="ABC")*('Resource Details'!$H$3:$H$295="123"),('Resource Details'!$M$3:$M$295),0))} entered as an array function it worked for me Lance "JC" wrote: I have an IF formula which will display the proper result in the functional arguments pop-up but not within the cell itself. I thought this was a simple format error on the cell but I verified it is set as a number but still displays "0" as the result. Formula is: =SUM(IF(('Resource Details'!$D$3:$D$295="XYZ")*('Resource Details'!$F$3:$F$295="ABC")*('Resource Details'!$H$3:$H$295="123"),('Resource Details'!$M$3:$M$295))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying how many results in a vlookup | Excel Discussion (Misc queries) | |||
| Displaying Formula Results in Cell | Excel Discussion (Misc queries) | |||
| Displaying formula rather than results... | Excel Discussion (Misc queries) | |||
| functions are not displaying the results | Excel Worksheet Functions | |||
| Sorting and displaying different results | New Users to Excel | |||
Hybrid Mode
