SUMPRODUCT formula revision

[Lil Stinker]

Hello,
I am using the following SUMPRODUCT formula to count the number of dates that fall within a 14 day period.
=SUMPRODUCT((H2:H10000>=TODAY())*(H2:H10000<=TODAY()+14))

How do I alter this to count only the dates based on certain criteria in column C? For instance, in the data set example below, how do I count only the return dates where "*CP200*" shows or just the return dates where "*Charger*" is listed?

Book1.xlsm
	A	B	C	D	E	F	G	H
1	Item ID	SerialNumber	Model	Description	Status	Location	DateOut	ReturnDate
2	47	6878	Motorola Radius CP200	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
3	64	50654	Motorola Radius CP200	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
4	65	7894	Motorola Radius CP200	UHF 16 Channel Walkie	IN	Warehouse
5	66	8183	Motorola Charger	UHF 16 Channel Walkie	IN	Warehouse
6	67	9504	Motorola Charger	UHF 16 Channel Walkie	IN	Warehouse
7	68	9545	Motorola Charger	UHF 16 Channel Walkie	IN	Warehouse
8	69	10500	Motorola Power Supply	UHF 16 Channel Walkie	IN	Warehouse
9	70	11050	Motorola Radius CP200	UHF 16 Channel Walkie	IN	Warehouse
10	71	12005	Motorola Radius CP200	UHF 16 Channel Walkie	IN	Warehouse
11	72	18456	Motorola Charger	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
12	73	25452	Motorola Power Supply	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
13	74	25453	Motorola Power Supply	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
14	75	65006	Motorola Power Supply	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
15	76	80000	Motorola Radius CP200	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
16	77	5500	Motorola Radius CP200	UHF 16 Channel Walkie	IN	Warehouse
17	78	6500	Motorola Charger	UHF 16 Channel Walkie	IN	Warehouse
18	79	94658	Motorola Charger	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
19	80	85858	Motorola Radius CP200	UHF 16 Channel Walkie	OUT	OC Carnival Event	2/3/2023	2/13/2023
Sheet2

 

[Lil Stinker]

in the formula in post #4, I removed the TODAY() function and hard coded a date in K1 so you can get results. Using TODAY with your data gets a zero as of today.

@awoohaw, thank you but as Joe suggested, I used the SUMPRODUCT method back in the day because I didn't know of the alternatives. This works too however, with my particular set up, the return dates are dynamic so I wouldn't be able to hard code the date to another cell. I could see how this method would work if you were perhaps searching by a specific date so I'll keep this in my pocket for later!

 

[Joe4]

@Joe4 Works like a charm! If I wanted to add farther date ranges, I could just change 14 to 30 or 60 or 90 days?

Yep, you can adjust the date range to suit your needs.