Need to Match Multiple Results and Count Text in Different Column

[jeffsmarketplace]

Sorry about the confusing subject line. I don't know squat about
Excel. Every time I try to tackle something I spend hours reading and
trying different things. This time I am stumped, I don't speak excel
and I can't string formulas together to get the results I want, so I
am hoping somebody can hep me.

A B C D
Jim Home Dog Car
John Condo Cat Bike
Jim Home Dog Car
Mike Box Rat Walk
Jim Home Dog Truck


What I need to do is look up how many "jims" there are and return the
results of column "D", but I need to count "CAR" returning "2" and
count "Truck" returning 1. I plan on doing this in two separate
columns. I have used the VLOOKUP formula and can get it to say "CAR",
but I want it to find how many occurences of "JIM" there are and total
the number of "CARS" or "TRUCKS". Again I will look for "JIM" in one
column returning "CAR" and Look for "Jim" in another column returning
"Truck"

Any help would be appreciate,

Jeff

 

[Don Guillett Excel MVP]

Sorry about the confusing subject line. I don't know squat about
Excel. Every time I try to tackle something I spend hours reading and
trying different things. This time I am stumped, I don't speak excel
and I can't string formulas together to get the results I want, so I
am hoping somebody can hep me.

A          B         C      D
Jim    Home    Dog  Car
John   Condo   Cat   Bike
Jim    Home    Dog   Car
Mike   Box      Rat    Walk
Jim     Home   Dog    Truck

What I need to do is look up how many "jims" there are and return the
results of column "D", but I need to count "CAR" returning "2" and
count "Truck" returning 1. I plan on doing this in two separate
columns. I have used the VLOOKUP formula and can get it to say "CAR",
but I want it to find how many occurences of "JIM" there are and total
the number of "CARS" or "TRUCKS". Again I will look for "JIM" in one
column returning "CAR" and Look for "Jim" in another column returning
"Truck"

Any help would be appreciate,

Jeff

to count jim car=2 use
=sumproduct((a2:a22="jim")*(d2:d22="car"))

 

[jeffsmarketplace]

to count jim car=2 use
=sumproduct((a2:a22="jim")*(d2:d22="car"))- Hide quoted text -

- Show quoted text -

Thank you I thought I tried that one, but will try again.

 

[jeffsmarketplace]

to count jim car=2 use
=sumproduct((a2:a22="jim")*(d2:d22="car"))

That worked, I truly appreciate it.

 

[Don Guillett Excel MVP]

That worked, I truly appreciate it.- Hide quoted text -

- Show quoted text -

Glad to help