I am tracking compliance percentages (2 rows per calendar day). I want a rolled-up matrix of the averaged results for the previous month. I want the average part of the statement to ignore blanks and errors (not column item is required every day) but include zeros (indicates non-compliance). I...
I have to find average number of days if status = new or open,severity= 4,area=Apps
Demo table
Area Severity Status No of days
Apps 4 new 20
Apps 3 open 10
Node 3 close...
Good afternoon,
I am trying to see if it's possible to create an average/if type formula.
Basically I have 2 columns of reference, E and J. E is the date closed and J is the date logged. I want to look and see the average amount of days open per month.
For instance, If the date in column E...
I need to average a list of numbers, excluding the number zero. Example list: 1, 0, 2, 2, 0, 5, 0.
How can you average 1, 2, 2, 5 AND exclude the zeros from calculation?
Thanks!