Thread: How do I add cell values using conditional criteria?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ansoriano1 ansoriano1 is offline
external usenet poster
  
Posts: 9
Default 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?


Reply With QuoteReply With Quote