Count Ifs - Help

Question

Hi:&nbsp;I ma trying to do a =COUNTIFS function based on multiple date values and criteriaI can't seem to get it to work.&nbsp;I have successfully set up multiple criteria counts in the past, but I am not sure how to choose 1 value from each column if criteria is met.&nbsp;Note:Assume Today is 12/12/18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OwnerPlan_DateReplan DateActual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Steve11/30/201812/12/201812/12/2018&nbsp;&lt;Anything with an Actual should not countJane11/25/201812/15/2018(blank)&nbsp;(blank) is an actual value from the database exportSteve10/15/201812/16/2018(blank)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bob10/22/201812/31/2018(blank)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thomas12/15/2018(blank)12/10/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;George12/14/2018(blank)(blank)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Items Coming Due in the next seven days (based on the higher of the Plan or replan Date), and Actual = (blank):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BobValue here'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Steve&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Jane&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thomas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;George&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

cms_models · Answer

Ok.&nbsp; I'm getting closer.I'd like to Replace the G3:G9 Range with a =MAX Statement, but I am having difficulties, getting it to work.&nbsp; The other parts of the formula are fine&nbsp;&nbsp;=COUNTIFS(G3:G9,"&gt;="&amp;TODAY(),G3:G9,"&lt;="&amp;TODAY()+7,D3:D9,"="&amp;"(blank)",A3:A9,"="&amp;I4)

Forum Discussion

Count Ifs - Help

Share

Resources

Note:	Assume Today is 12/12/18

Owner	Plan_Date	Replan Date	Actual
Steve	11/30/2018	12/12/2018	12/12/2018	<Anything with an Actual should not count
Jane	11/25/2018	12/15/2018	(blank)	(blank) is an actual value from the database export
Steve	10/15/2018	12/16/2018	(blank)
Bob	10/22/2018	12/31/2018	(blank)
Thomas	12/15/2018	(blank)	12/10/2018
George	12/14/2018	(blank)	(blank)

	Items Coming Due in the next seven days (based on the higher of the Plan or replan Date), and Actual = (blank):

	Bob	Value here'
	Steve
	Jane
	Thomas
	George