Kind Sir/Madam,
Greatly appreciate any help on the following:
I created an extra sheet with formula's so I can have them displayed in a dashboard without having to add all kind of formulas and outcome of these formulas in my source sheet. My goal is to count the number of "approved" and "completed" quotations (same column) in a reference sheet.
Short crash course in Dutch:
AANVAARD means approved
AFGEROND means completed
With one criteria it works fine:
=COUNTIF({Fase}; "AFGEROND")
But when I add the second criteria, please note it has to be either the first "AANVAARD" or "AFGEROND"
I've tried to use the @cell way as was advised by Brian W in this article :
=COUNTIFS({Fase}; @cell = "AANVAARD", {Fase}; @cell = "AFGEROND"))
but I get an "UNPARSEABLE" error
I also tried this:
=COUNTIFS({Fase}; "AANVAARD"; {Fase}; "AFGEROND")
but ofcourse it comes up with zero, so I added OR to the formula:
=COUNTIFS({Fase}; "AANVAARD"; OR {Fase}; "AFGEROND")
I called Smartsheet for help. Very friendly staff but they needed some time to figure out the formula and I just cannot stand it them I'm not able to figure this one out.
Thanks for the help, much appreciated.
Kind regards,
Mike
