Hi there,

How can you averageifs with sales greater than zero for a specific vendor.

This formula shows #VALUE! but I believe it's correct.

i.e. =AVERAGEIFS(SALES,VENDOR_NAME,B4,SALES,">0")

Any help would be greatly appreciated

Thank you.