Formula help

[Bubba]

A B C D E
Date Type Customer Stock # Model
8/28/2006 CT S Thundathil 70172A Silverado
9/1/2006 NC Kieran Egana 60861 Cobalt
9/1/2006 UT Julieann Dovey 61010A1 Silverado
9/1/2006 UT William Dovey 61148A Silverado
9/1/2006 NT Shayla Gilbert 70155 Tahoe
9/1/2006 NT Gayle Ellenburg 61238 Silverado
9/1/2006 UT Bilie Downs 60902B Truck
9/1/2006 UC Harvey Flowers P4428A Cobalt

I want to the total number of column B that equals NT and column E that equals Silverado what would the formula be.

Thanks

[VBA Noob]

Hi,

I had a column F so you might need to amend.

But the below will count how many times the pair match "NT" & "Silverado"

=SUMPRODUCT(--($B$2:$B$100="NT")*($F$2:$F$100="Silverado"))

VBA Noob

[Bubba]

Worked

Thanks