So I am trying to make a metric sheet that uses a COUNTIFS sorting by month, year, lane, and to only count if approve is check. I will make a dashboard that eventually sorts by the lanes (3 of them in total) and it will be tracked for trends in change in months and years. Below is the sheet that is connected to a form where data gets dumped into. I will have multiple different of these sheets because I have many different units. So again, I will want the countifs taking both the month and year in the date, the lane (1,2, or 3), and I only want it to work if the box is checked.
These last 2 pictures are the metric sheet I am making. here is a zoomed in picture of the first table I will use which is for lane 1. The second picture is the formula i have been trying to tinker with. I know I have to add a countifs to sort the three different types of lanes also into it. If anyone could help me with this it would be greatly appreciated! I can also provide more information if that would help. Thanks!
