Count Ifs - Help

[cms_models]

Hi:

I ma trying to do a =COUNTIFS function based on multiple date values and criteria

I can't seem to get it to work.

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.

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

[#2]

Ok.  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.  The other parts of the formula are fine

=COUNTIFS(G3:G9,">="&TODAY(),G3:G9,"<="&TODAY()+7,D3:D9,"="&"(blank)",A3:A9,"="&I4)