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 15 hours 45 minutes ago

I'd create a helper column, for example in column Z on the Inventory sheet.

In Inventory!Z2: =(E2=G2)

Fill down to the end of the data.

On the Summary sheet:

In C2: =COUNTIF(Inventory!B:B,B2)

In D2: =COUNTIFS(Inventory!B:B,B2,Inventory!Z:Z,TRUE)

In E2: =COUNTIFS(Inventory!B:B,B2,Inventory!Z:Z,FALSE)

In F2: =COUNTIFS(Inventory!B:B,B2,Inventory!H:H,"CA")

In G2: =COUNTIFS(Inventory!B:B,B2,Inventory!H:H,"WA")

Select C2:G2 and fill down as far as needed.