custom formula for getting average...

[Tonyk1051]

Book1.xlsx

so attached is a link to the file. i know how to use the function but as you can see in the work book. im trying to get the average days (column k) for each vendor (column c), i can do it manually for each vendor, copy paste the data but its going to take forever. is there a unique formula i can use for column M? thanks in advance

 

[Ruddles]

Something along these lines?

=SUMIF(C:C,C2,K:K)/COUNTIF(C:C,C2)

 

[Fluff]

Another option

=AVERAGEIFS(K:K,C:C,C2)

 

[Tonyk1051]

Something along these lines?

=SUMIF(C:C,C2,K:K)/COUNTIF(C:C,C2)

it worked, thanks ruddles

 

[Fluff]

Did you try the formula I suggested which should be more efficient?

 

[Tonyk1051]

Did you try the formula I suggested which should be more efficient?

yes i tried yours too, it worked and im grateful, thanks fluff

 

[Fluff]

Glad we could help & thanks for the feedback.