Sumproduct based on certain criteria
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 CAAC22 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' or 'B' and C=John.
I tried the formual
=sumproduct(--(a$2:a$9999="auto"),--(B$2:B$9999="A?????")--(C$2:C$9999="John"),f$2:F$9999).
but its not working. Could you please help me on this formula..
Thanks in advance
--
Karthi
|