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

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