IF formula results not displaying

J

JC

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

LanceB

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top