Forum Discussion
Sum returns 0
I have a data validation list in column C.
In column D I have this formula:
=IF(OR(C$5:C$30="400 Confirmation Calls",C$5:C$30="1100 Inbound Calls",C$5:C$30="430 Appts Created"),1,"")&IF(OR(C$5:C$30="420 Confirmation Calls",C$5:C$30="1200 Inbound Calls",C$5:C$30="450 Appts Created"),2,"")&IF(OR(C$5:C$30="450 Confirmation Calls",C$5:C$30="1300 Inbound Calls",C$5:C$30="470 Appts Created"),3,"")
At the bottom of column D I want it to sum up the total for all of D and for some reason it just returns "0".
Make sure to enter the second formula by pressing Ctrl+Shift+Enter as I mentioned before, this keystroke shortcut will force the formula to deliver the right result.
Give it a try.
It's a common issue!
Quick solution:
=SUMPRODUCT(VALUE(SUM RANGE))
Please refer to my answer to this question to learn more about this issue!
It didnt seem to work... or I did it wrong which is much more probable.
I put
=SUMPRODUCT(VALUE(d5:d29))
I only want it to sum up the range D5:D29
It should work!
Let me know what its result!
Is it 0 or something else?
