luisitocarrion1900
Board Regular
- Joined
- Oct 30, 2017
- Messages
- 194
- Office Version
- 365
- Platform
- Windows
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”
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 |