I am attempting to create a forumula which references another sheet; however, I continue to receive error messages or it doesn't calculate correctly. Below is the outline of what I am looking to accomplish. Let me know if you can help.
One column called Program with drop down options of Service Expansion, Frontline Fast, Readyline Express.
Another column called Status with drop down options of Qualifying, Initial Meeting/Needs Analysis, Proposal, Negotiation, Closed Won, Not Interested, Doesn’t
I am trying to create a formula, in a seperate worksheet, that will count all the ‘Service Expansions’ in the program column WHEN the Status is “Qualifying, Initial Meeting/Needs Analysis, Proposal, or Negotiation”.
I have attached a screen shot of the formula I have currently. I have also tried a countif / if statement with no success.
Appreciate any assistance.
Help Article Resources
Check out the Formula Handbook template!