Count Excel formula

[luisitocarrion1900]

I need a formula that will count if

Sheet name “Data”

Column header Asset Type has the name “VEHICLES” and

Column header QTR Rptd has the name “Q2” and

column header Prior/Current has the name “Prior”, “Current” and

Column Header Category of Acquisition has the named “Acquisition”, “Transfer”

Asset Type	Asset Number	Acquisition Date	Qtr Rptd	Prior/Current	FY and/or Qtr	Category of Acquisition
VEHICLES	AVIS 201971030	1/3/2020​	Q2	Current	FY 2020 Q2	Acquisition
VEHICLES	AVIS 201941007	12/12/2019​	Q2	Current	FY 2020 Q1	Acquisition
VEHICLES	AVIS 201971039	1/10/2020​	Q2	Current	FY 2020 Q2	Acquisition
VEHICLES	AVIS 202035036	1/30/2020​	Q2	Current	FY 2020 Q2	Acquisition
VEHICLES	AVIS 202051006	11/14/2017​	Q2	Prior	FY 2018	Acquisition
VEHICLES	AVIS 202051007	11/14/2017​	Q2	Prior	FY 2018	Acquisition
VEHICLES	AVIS 202031023	12/31/2019​	Q2	Current	FY 2020 Q1	Acquisition
VEHICLES	AVIS 202032019	2/7/2020​	Q2	Current	FY 2020 Q2	Acquisition
VEHICLES	AVIS 201680007	12/12/2019​	Q2	Current	FY 2020 Q1	Acquisition
VEHICLES	AVIS 201830127	5/28/2019​	Q2	Current (see comment)	FY 2019	Transfer

 

[Oeldere]

did you consider using pivot table for that?