Averageif

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.

Hi

You can use averageifs() to find the average of each department ignoring the zeros

=AVERAGEIFS(B2:B8, A2:A8, "Sales", B2:B8, ">0")


“If you upload your sheet to google sheets and use the google sheets plug in called Formula Helper it may be helpful to you.”