=Countblank with 2 other criteria

[Ghost141]

Hi gang, Trying to suss out the formula to count the blank cells in column B dependant on date and status.

For "approved", I want to count any blank cells older than 24 hours, for declined, i want to count blank cells older than 14 days.

Thanks!

Book3
	A	B	C
1	3/15/24	C2024-12345678	Approved
2	3/16/24	C2024-12345679	Approved
3	3/17/24		Approved
4	3/18/24	C2024-12345681	Approved
5	3/19/24	C2024-12345682	Declined
6	3/20/24		Declined
7	3/21/24	C2024-12345684	Declined
8	3/22/24	C2024-12345685	Approved
9	3/23/24	C2024-12345686	Approved
10	3/24/24		Approved
11	3/25/24	C2024-12345688	Approved
12	3/26/24	C2024-12345689	Declined
13	3/27/24	C2024-12345690	Declined
14	3/28/24		Declined
15	3/29/24	C2024-12345690	Declined
16	3/30/24	C2024-12345690	Declined
17	3/31/24		Approved
18	4/1/24	C2024-12345690	Approved
19	4/2/24	C2024-12345690	Approved
20	4/3/24		Approved
21	4/4/24	C2024-12345690	Approved
22	4/5/24	C2024-12345690	Approved
23	4/6/24		Declined
24	4/7/24	C2024-12345690	Declined
25	4/8/24	C2024-12345690	Declined
26	4/9/24		Declined
27	4/10/24	C2024-12345690	Declined
28	4/11/24	C2024-12345690	Declined
29	4/12/24		Declined
30	4/13/24	C2024-12345690	Declined
31	4/14/24	C2024-12345690	Declined
32	4/15/24		Declined
33	4/16/24	C2024-12345690	Declined
34	4/17/24	C2024-12345690	Declined
Sheet1

 

[Alex Blakenburg]

See if this works for you.

=COUNTIFS($B$1:$B$34,"",$A$1:$A$34,"<"&TODAY()-14)

I would recommend putting Today() in a cell perhaps called Report Date. This will give you some ability to control the report for when you are testing it or need to run the report for Yesterday or some other previous period

 

[RobP]

just correcting for the "approved" and "declined" selection also :

=COUNTIFS(B$1:B$34,"",C$1:C$34,"Approved",A$1:A$34,"<"&TODAY()-1)

=COUNTIFS($B$1:$B$34,"",C$1:C$34,"Declined",$A$1:$A$34,"<"&TODAY()-14)

 

[Ghost141]

Amazing thank you!