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 QTR Rptd has the name “Q2” and

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

Column Header Category of Acquisition has the named “Acquisition”

Asset Type	Asset Number	Acquisition Date	Qtr Rptd	Prior/Current	FY and/or Qtr	Category of 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 202071017	12/3/2014​	Q2	Prior	FY 2015	Acquisition
VEHICLES	AVIS 202075008	12/6/2017​	Q2	Prior	FY 2018	Acquisition

 

[sandy666]

Duplicate

 

[luisitocarrion1900]

Not a Duplicate the second is asking for additional names in teh column

 

[sandy666]

You can post this in previous thread
but of course you can do what you want

 

[luisitocarrion1900]

Ok, Thanks. Last time I did that I was asked to ask in separate post.

 

[AhoyNC]

If your version of 365 has the FILTER function try:

Book1
	A	B	C	D	E	F	G
1	Asset Type	Asset Number	Acquisition Date	Qtr Rptd	Prior/Current	FY and/or Qtr	Category of Acquisition
2	VEHICLES	AVIS 202051006	11/14/2017	Q2	Prior	FY 2018	Acquisition
3	VEHICLES	AVIS 202051007	11/14/2017	Q2	Prior	FY 2018	Acquisition
4	VEHICLES	AVIS 202051008	11/14/2017	Q2	Current	FY 2019	Acquisition
5	VEHICLES	AVIS 202051009	11/14/2017	Q2	Prior	FY 2020	Test
6	VEHICLES	AVIS 202071017	12/3/2014	Q2	Prior	FY 2015	Acquisition
7	VEHICLES	AVIS 202075008	12/6/2017	Q2	Prior	FY 2018	Acquisition
8
9	Count	4
Sheet1

Cell Formulas
Range	Formula
B9	B9	=ROWS(FILTER($A$2:$G$7,($A$2:$A$7="VEHICLES")*($D$2:$D$7="Q2")*($E$2:$E$7="Prior")*($G$2:$G$7="Acquisition")))

 

[ebea]

Or another option: =COUNTIFS($A$2:$A$7,"VEHICLES",$D$2:$D$7,"Q2";$E$2:$E$7,"Prior";$G$2:$G$7;"Acquisition")

 

[luisitocarrion1900]

what about if am placing the formula in sheet data but the information is pulling from Sheet1

 

[ebea]

Put sheet reference into the formula
=COUNTIFS(Sheet1!$A$2:$A$7,"VEHICLES",Sheet1!$D$2:$D$7,"Q2",Sheet1!$E$2:$E$7,"Prior",Sheet1!$G$2:$G$7,"Acquisition")