Forum Discussion
Solved
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...
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.
So the first formula you gave me returned the #VALUE! error. The second formula just comes up as 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.
YOU ARE A GENIUS!! THANK YOU