How do I add cell values using conditional criteria?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ansoriano1 - 20 Oct 2006 01:05 GMT

Here's my sheet

Company|Zone | Units
________________
A | 1 | 3
B | 2 | 4
A | 3 | 2
A | 1 | 7

What I want to do is get the average number of units from Company A in Zone 1.

Can somebody help me?

Reply to this Message

Bob Phillips - 20 Oct 2006 01:21 GMT

=SUMPRODUCT(--(A2:A20="A"),--(B2:B20=1),C2:C20)

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Here's my sheet
>
[quoted text clipped - 8 lines]
>
> Can somebody help me?

Reply to this Message

Teethless mama - 20 Oct 2006 03:48 GMT

=AVERAGE(IF((A1:A100="A")*(B1:B100=1),C1:C100))

ctrl>shift>enter (not just enter)

> Here's my sheet
>
[quoted text clipped - 8 lines]
>
> Can somebody help me?

Reply to this Message