Hi

Try:
=SUMPRODUCT((A2:A100="D")*(C2:C100="John"))
Note that the ranges in SUMPRODUCT must be the same size - and cannot be
full columns

Andy.

"Laur" wrote in message
...
I need to count how many times "D" comes up in column A but only when
ordered
by John in Column C.

TYPE CUSTOMER ORDERED BY
D TRICIN JONATHAN
D ATLANTIC PKG. DAN
D ATLANTIC PKG. JOHN
E SONCIN PAUL

I hope this makes sense and thanks for the help.