IF formula results not displaying

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JC - 29 May 2008 18:19 GMT

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 to this Message

LanceB - 29 May 2008 19:09 GMT

{=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

> 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
[quoted text clipped - 3 lines]
> Details'!$F$3:$F$295="ABC")*('Resource Details'!$H$3:$H$295="123"),('Resource
> Details'!$M$3:$M$295)))

Reply to this Message