Formula with using three separate columns
I am trying to write a formula that counts the number of PINS Case_FRB based on Force Level_FRB and within a specific date range. I'm using the formula below, but it is not working.
=COUNTIFS([Date Presented to FRB]1:[Date Presented to FRB]205, AND(@cell >= DATE(2021, 2, 1), @cell <= DATE(2021, 5, 5)), [Force Level_FRB]1:[Force Level_FRB]205, @cell = "SUoF / L3"), [PINS Case_FRB]:[PINS Case_FRB], AND(@cell = "PINS"))
I am also trying to write a formula using a begins with statement. I would like to count all case numbers that begin with "19-".
I attempted the formula below but it returned a #unparseable error.
=COUNTIFS([Force Level_FRB]:[Force Level_FRB], "Tactical" AND [Case Number]:[Case Number], or(@cell = "19-*"))
Help is appreciated!
Help Article Resources
Check out the Formula Handbook template!