Hi Shrikanth,

Iif you are looking to get the avarage based on your condition,
assuming that your data is in A1:B6

=AVERAGEIFS(B1:B6,B1:B6,"0",A1:A6,"=a") will give you 28.5

Thanks,

Abdul