Trending in Formulas and Functions
-
COUNTIFS formula to pull number of overdue tasks associated with owner
I am trying to pull data for a Sheet Summary with this formula: =COUNTIFS([Owner:Owner], "jane doe", [Deadline:Deadline], "<" & TODAY()) I am getting an unparseable error, it seems to be around the () next to TODAY. What do I need to change to have my formula be correct?
-
Distinct Count IF or Running Count Total
Good Morning All, I need a formula to count the running total of the Dealer Names as they appear. The current formula I have in Column 14: =COUNTIFS(Dealer:Dealer, Dealer@row) is showing the total times Dealer Name is referenced. In my situation I would need "TriGreen Equipment - Ag & Turf" is referenced twice but has two…
-
Can you use sum and min together
Hello, Im trying to get a min of 4 if PA points and SS points are both active then have 4 or the number that is either ss or pa add to the other columns, is that possible? Here's the formula I came up with but its not working. =IFERROR(IF(OR([Status Detail]@row = "Ready to return", [Status Detail]@row = "Transfer"), "N/A",…