Trending in Formulas and Functions
-
COUNTIFS with start date, end date and multiple criteria
Hi all, I tried searching for this and I found a few things that came close but this formula request has a bit of an extra layer. I have a report that is currently achieving this and now I need to write a formula in order to put that number on a dashboard. The reports filter criteria is as follows: If "Status" is not one…
-
CountIfs Function to Determine if Completed on Time
Hi, I am trying to put together a formula sheet from our data in our inventory. Within the inventory, each project is assigned to someone and given a due date, they will manually enter their completion date. I want the formula to count # of projects someone completes on time. Here is my current formula: =COUNTIFS({Assigned…
-
Calculating 2 criteria from one column up to a specific date, also including a check box reference
I'm trying to calculate data from a status column that has drop down options of 'in progress' and 'not started' and see how many from those 2 criteria return an end date up to the end of June 2024 (working days will be 28 June). Also ensuring that a check box for if it's being reported is checked. I'm using a sheet…