Matt Brown via OfficeKB.com wrote...
...
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.

Unclear. First, by 'totalled' do you mean counted? Second, since all
Mustangs are Fords, when would B = Mustang but C < Ford?

Also, it's always a good idea to show the formula you've tried to use
rather than make everyone else guess where your mistakes may lie.

If you want the count of all V8 Mustangs, use

=SUMPRODUCT(--(A2:A100="V8 ENGINE"),--(B2:B100="MUSTANG"))

If you want the count of all Ford Mustangs, use

=COUNTIF(B2:B100,"MUSTANG")

and check for the validity of your data using

=SUMPRODUCT(--(B2:B100="MUSTANG"),--(C2:C100<"Ford"))


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=275820