Hello,
This is my current formula - just counting the number 'Critical' references from F11:F32.
Question 1:
=COUNTIF($F$11:$F$32,"Critical")
How would I modify this to include the number of "Critical" within 1 calendar month (meaning each month of the year)?
Question 2:
=COUNTIF($F$11:$F$32,"Critical")
How would I modify this to include the number of "Critical" within 1 calendar month (meaning each month of the year) AND If Column G is = Open, count only those instances (within the calendar month)?
Bookmarks