Is there a way to make the average funtion work in vba so that it
selects only values 0 in a given range?
Something like
avv = Application.WorksheetFunction.Average(if(Range("'d ata'!" & srt) 0))

=average(if(b2.b5000))

works in excel and I'd like the equivqlent in vba if possible
Thanks
Chris