Not really sure what you want, but you can count the conditions you want
with

=SUMPRODUCT(--(A1:A100="V8 ENGINE"),--(B1:B100="MUSTANG"))

and

=SUMPRODUCT(--(B1:B100="MUSTANG"),--(C1:C100="FORD"))
--

HTH

RP
(remove nothere from the email address if mailing direct)


"Matt Brown via OfficeKB.com" wrote in message
...
The problem i have is this: -

I am using a SUMPRODUCT statement and need to know if you can use hierachy
in the conditions and if so how i go about it?

ie. I have 3 conditions ie A, B & C.

A = V8 ENGINE
B = MUSTANG
C = FORD

If A & B are true I want condition A (V8 Engines) to be totalled. If B & C
are true I want B (Mustangs) to be totalled.

The problem im having is that if A & B are true, I am getting a total for
all vehicles that are MUSTANGS rather than just MUSTANGS with V8 engines.
Likewise if B & C are true I am getting a total for all FORDS rather than
just FORD MUSTANGS.

*****************************************
* This message was posted via http://www.officekb.com
*
* Report spam or abuse by clicking the following URL:
*
http://www.officekb.com/Uwe/Abuse.as...583ac503e4892a
*****************************************