AnsweredAssumed Answered

Excluding zero from a summary

Question asked by Koerkel on Aug 6, 2019

In my VBA code, I am using the function to get an event weighted average.  I notice that this function includes all values.  Is it possible to exclude/filter out some values? If not is there another function I could use to exclude values?  


The reason for my ask, I'm trying to calculate the average voltage over a six month period and I want to exclude any power outage where the voltage equals zero.