Hi All,
I would like to filter column B and display in column E all numbers that are bigger than 1.
Also if possible I would like to display in column E an average of all numbers from column B that are bigger than 1.
The reason why: daily i am downloading flow rates of our pumps. Pump is not working all the time and every time it stops it will showe it as 0. I need to calculate daily average flow but only when pump was working
Document attached
Thank you
Bookmarks