Getting Count from Sheet1 based on criteria Possibly use of COUNTIF

Sheet1Sheet2

I have a workbook with two sheets.

Sheet1 has the data and Sheet2 is a summary sheet I am able to use CountIF to pull the car count based on model using =COUNTIF(Inventory!B:B,"NIssan" (col C sheet2). My challenge is populating col D, ColE, ColF and ColG. Hope someone can help me with the correct fomula for these.


  • Edited by Kd01 Friday, March 27, 2015 3:43 PM
March 27th, 2015 3:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics