ExcelBanter - How do I add cell values using conditional criteria?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I add cell values using conditional criteria? (https://www.excelbanter.com/excel-worksheet-functions/115282-how-do-i-add-cell-values-using-conditional-criteria.html)

ansoriano1

How do I add cell values using conditional criteria?

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?

Bob Phillips

How do I add cell values using conditional criteria?

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

--
HTH

Bob Phillips

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

"ansoriano1" wrote in message
...
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?

Teethless mama

How do I add cell values using conditional criteria?

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

ctrlshiftenter (not just enter)

"ansoriano1" wrote:

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?

All times are GMT +1. The time now is 02:00 AM.