count if multiple criteria

[blackstar]

Ok i need to get a total count of apples in column D but only if
column A says oranges,
column B says kiwi
column C says berry

if column A, B, C fit all of those criteria i want to know the count of how many times the word Apples in column D appears. make sense?
i can't quite get the formula right for it, any help would be great thx!

[Maistrye]

Use:
=SUMPRODUCT(--(A1:A100="apples"),--(B1:B100="oranges"),--(C1:C100="kiwi"), --(D1:D100="berry"))

See the following link for an explanation of the whys and hows.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Scott

[RobertCo]

I used the following
'=SUMPRODUCT(--(D7:D100="Apples")*(--(A7="Oranges")*(--(B7="Kiwi")*(--C7="Berry"))))
Which sums the Apples in Column D rows 7 through 100 IF Column A Row 7 has the word Oranges and IF Column B Row 7 has the word Kiwi and IF Column C Row 7 has the word Berry

Hope this helps.

[blackstar]

ok. great formula. trouble is i gave the slightly wrong question sorry!!. what i actually need is the following
sum all totals (numbers) in column D
but only if the same rows in column A is oranges,
column B is kiwi
& column C is berry.

does that make sense?

[Maistrye]

=SUMPRODUCT(--(A1:A100="oranges"),--(B1:B100="kiwi"),--(C1:C100="berry"), D1:D100)

Scott

[blackstar]

thank you! that worked perfectly