jgedwardsv
New Member
- Joined
- Oct 27, 2016
- Messages
- 31
Hi all!
I'm trying to pull averages and exclude any zeros from the calculation. What I have right now is:
=AVERAGE(VLOOKUP([@SeriesName],FundData[[#Headers],[#Data],[FullName]:[2000]],{4,5,6},FALSE))
Unfortunately this formula treats anything in that array that comes back that is blank as a zero. I have tried AVERAGEIF with the "<>0" criteria, however, excel keeps giving me an error. Is there something I am doing wrong or does excel averageif not work with a vlookup array?
Thanks for your help!
John
I'm trying to pull averages and exclude any zeros from the calculation. What I have right now is:
=AVERAGE(VLOOKUP([@SeriesName],FundData[[#Headers],[#Data],[FullName]:[2000]],{4,5,6},FALSE))
Unfortunately this formula treats anything in that array that comes back that is blank as a zero. I have tried AVERAGEIF with the "<>0" criteria, however, excel keeps giving me an error. Is there something I am doing wrong or does excel averageif not work with a vlookup array?
Thanks for your help!
John