=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?