How to count using multi criteria

[rentonhighlands]

Please help me write a formula -
At each site code, I want to count how many total connections are delivered.
At each site code, I want to count how many total connections are estimated to be delivered.
At each site code, I want to count separately how many internet connections are delivered at a site.
At each site code, I want to count separately how many Private connections are delivered at a site.
At each site code, I want to count separately how many internet connections are estimated to be delivered.
At each site code, I want to count separately how many Private connections are estimated to be delivered.

Site Code	Site Name	Transport Type A	Carrier Estimated Delivery Date	Delivery Date
Test 1	Name 1	Internet	1/31/2025
Test 2	Name 2	Private	5/31/2025
Test 2	Name 2	Internet	5/31/2025
Test 2	Name 2	Private	5/31/2025
Test 2	Name 2	Internet	5/31/2025
Test 3	Name 3	Internet	5/31/2025
Test 3	Name 3	Private	5/31/2025
Test 3	Name 3	Private	9/30/2025
Test 3	Name 3	Internet	9/30/2025
Test 4	Name 4	Private	4/30/2025
Test 4	Name 4	Private	4/30/2025
Test 4	Name 4	Internet	4/30/2025
Test 4	Name 4	Internet	4/30/2025
Test 5	Name 5	Private	4/30/2025
Test 5	Name 5	Private	4/30/2025
Test 5	Name 5	Internet	4/30/2025
Test 5	Name 5	Internet	4/30/2025
Test 6	Name 6	Private
Test 7	Name 7	Internet	12/14/2024
Test 7	Name 7	Private	12/14/2024
Test 7	Name 7	Internet	12/14/2024

 

[AhoyNC]

Depending on how you want to see your data you couuld use the PIVOTBY or GROUPBY functions.
Here are some links on how to use.

My examples below are for sites that have an estimated delivery date.
Note that the VSTACK function I used with GROUPBY was just to add headers.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Site Code	Site Name	Transport Type A	Carrier Estimated Delivery Date	Delivery Date
2	Test 1	Name 1	Internet	1/31/2025				Internet	Private	Total
3	Test 2	Name 2	Private	5/31/2025			Test 1	1		1
4	Test 2	Name 2	Internet	5/31/2025			Test 2	2	2	4
5	Test 2	Name 2	Private	5/31/2025			Test 3	2	2	4
6	Test 2	Name 2	Internet	5/31/2025			Test 4	2	2	4
7	Test 3	Name 3	Internet	5/31/2025			Test 5	2	2	4
8	Test 3	Name 3	Private	5/31/2025			Test 7	2	1	3
9	Test 3	Name 3	Private	9/30/2025			Total	11	9	20
10	Test 3	Name 3	Internet	9/30/2025
11	Test 4	Name 4	Private	4/30/2025			Estimated Private Delivery
12	Test 4	Name 4	Private	4/30/2025			Site	Transport Type A	Count Est Delivery
13	Test 4	Name 4	Internet	4/30/2025			Test 2	Private	2
14	Test 4	Name 4	Internet	4/30/2025			Test 3	Private	2
15	Test 5	Name 5	Private	4/30/2025			Test 4	Private	2
16	Test 5	Name 5	Private	4/30/2025			Test 5	Private	2
17	Test 5	Name 5	Internet	4/30/2025			Test 7	Private	1
18	Test 5	Name 5	Internet	4/30/2025			Total		9
19	Test 6	Name 6	Private
20	Test 7	Name 7	Internet	12/14/2024
21	Test 7	Name 7	Private	12/14/2024
22	Test 7	Name 7	Internet	12/14/2024
23
Sheet2

Cell Formulas
Range	Formula
G2:J9	G2	=PIVOTBY(A2:A22,C2:C22,C2:C22,COUNTA,0,,,,,D2:D22<>"")
G12:I18	G12	=VSTACK({"Site","Transport Type A","Count Est Delivery"},GROUPBY(HSTACK(A2:A22,C2:C22),C2:C22,COUNTA,0,,,(D2:D22<>"")*(C2:C22="Private")))
Dynamic array formulas.