Average If Statement (Excel 2003)
 From: Viewpoint <Viewpoint@xxxxxxxxxxxxxxxxxxxxxxxxx>
 Date: Thu, 18 Dec 2008 10:48:19 0800
I am trying to find the formula for averaging cells in column B if the data
in Ais (a specific criteria). I've tried some formulas in the threads
related to average, but nothing seems to work.
Example:
If A1:A110 equals 01
Then Average B1:B110 (cells related to the criteria in A1:A110)
When using formulas, should cells have a specific format? Because there is
text involved, I set the cell format to general. Do you suggest differently?
Also, I'm working with data that I exported from a Microsoft Access 2007
database (SQL) but I'm using Excel 2003. Will this cause a problem?
.
 FollowUps:
 RE: Average If Statement (Excel 2003)
 From: bpeltzer
 RE: Average If Statement (Excel 2003)
 From: Gary''s Student
 Re: Average If Statement (Excel 2003)
 From: T. Valko
 RE: Average If Statement (Excel 2003)
 Prev by Date: Re: Special copying of columns
 Next by Date: Re: Adding columns
 Previous by thread: Macro to shift
 Next by thread: Re: Average If Statement (Excel 2003)
 Index(es):
Relevant Pages
