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 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”
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 |