How do I average if two conditions are present?
Posted by Roy on January 23, 2001 1:50 PM
I need some help writing an Excel formula. I am not all that savvy about Excel, so please forgive any dumb questions.
I want to find the average price of two parts which are almost (but not always) sold in pairs, and which have different prices due to the date of manufacture.
I have my spreadsheet columns named Price, BDF, DF2, and Date, and here is the way I have the data aranged:
A B C D
Unit Names of parts Manufacture
1 Price BDF DF2 Date
2 11.25 11W 44K 10/5/99
3 11.50 11W 22P 11/6/99
4 16.50 11Z 22P 11/7/99
5 12.40 11W 38Y 12/8/99
6 11.25 11W 22P 12/8/99
7 11.00 11W 22P 1211/99
8 12.50 11Z 22P 1/12/00
For example, the average price of the 11W-22P part pair is $11.25 ((11.50+11.25+11.00)/3), and the average price of the 11Z-22P part pair is $14.50 ((16.50+12.50)/2). I want to tell Excel what to do via a formula. Hope you can help a novice.