Hi
Use an unused column as helper column to extract the first letter in
Col B.

In this example I use column G as helper column.

Enter this formula in G2 and copy down:

=Left(B2,1)

Now use this formula to calculate the average:

=SUMPRODUCT(--(A$2:A$9999="Auto"),--(G$2:G$9999="A"),--(C$2:C
$9999="John"),F$2:F$9999)

Hopes this helps

---
Per


On 6 Feb., 02:41, Karthik wrote:
Hi All,
I have data with 6 columns and more than 2500 rows. *I want to find the
average of column "F" if all the other columns fulfill certain conditions..

Auto * *AAAC22 *John * *2 * * * 3 * * * 45.62
Auto * *AAAC22 *John * *2 * * * 3 * * * 13.1
Auto * *AAAC24 *Kelly * 6 * * * 3 * * * 14.5
Auto * *BAAC25 *John * *2 * * * 1 * * * 15
Manual *AAAC26 *John * *2 * * * 3 * * * 15.24
Auto * *AXAC22 *John * *5 * * * 3 * * * 45.62
Auto * *AAAC28 *Kelly * 1 * * * 1 * * * 15.55
Manual *AAAC22 *John * *2 * * * 3 * * * 45.62
Auto * *AAAC22 *John * *2 * * * 3 * * * 16.72

I would like to know a formula that calculates the average of 'F' if A=Auto,
B=Starts with letter 'A' and C=John.

I tried the formual
=sumproduct(--(a$2:a$9999="auto"),--(B$2:B$9999="A?????")--(C$2:C$9999="Joh*n"),f$2:F$9999).
but its not working. Could you please help me on this formula..

Thanks in advance

--
Karthi