Hello All,

My name is Lance and this is my first time posting here. Please forgive me if I have posted in the wrong spot (moderators please feel free to move) or for any "faux paus" I may make.

Here is my issue:

I need to find the average length of time that a person waits to be admitted. I need to do this for different floors and departments.

The information is all grouped together and a column has been added that calculates the length of time from when it is decided that a person should be admitted to when the orders have been written,

NOTE: The data is manually collected so there are some data entry issues that result in "0" or negative numbers. Sometimes a person changes their mind and leaves thus a blank cell.

So, for giggle, let's say the departments are named Alpha, Bravo, Charlie & Delta.

I have used averageif statements in the past and know there is a way to figure the average for each floor or department by ignoring the zeros, negative numbers and blank cells.

Any and all help is appreciated.