johnrobgray
New Member
- Joined
- Aug 21, 2017
- Messages
- 43
- Office Version
- 2013
- Platform
- Windows
Hi
I have the below formula
=IFERROR(IF((AND(K11="BT",L11="New Sale")),"1"),0)
I'm trying to get it to count when 2 cells have the above and when it doesn't meet it just presents a zero.
I've tried this and it still generates a FALSE error.
Any idea where I might be going wrong?
I have the below formula
=IFERROR(IF((AND(K11="BT",L11="New Sale")),"1"),0)
I'm trying to get it to count when 2 cells have the above and when it doesn't meet it just presents a zero.
I've tried this and it still generates a FALSE error.
Any idea where I might be going wrong?