SumIF? Want to track a vendor's rating.

[LisaM]

I have a spreadsheet where I track on a scale from one to five a vendor's job performance based on five criteria.

How do I average their overall rating, assuming one vendor can be used mulitple times because they may perform more than one job?

 

[Haldoug]

Have you looked in to using a pivot table with the vendor in the row label, the rating in the values, and using the drop down arrow to switch the values from sum to average under value field setting.

 

[LisaM]

Unfortunately, I have blank cells so a pivot table wouldn't work for me.

 

[Haldoug]

Unfortunately, I have blank cells so a pivot table wouldn't work for me.

The blank cells should only cause you to have to define the pivot table range differently, and have a blank cell line in your results.

 

[LisaM]

I will try that out and see what happens.