Need Help with formula to pull an average with a value <0 and equal to a name

[FinGhost]

I am putting together a spredsheet to track mortgage file processing time by processor. A4-A44 are the App Dates and in cells N4-N44 are the closed dates and Q4-Q44 I have already put in line by line the =Nx-Ax to get the processing days (If someone could help me with a formula auto fill commands to do Q=N-A line by line instead of manually doing it that would be great). Here is where it gets complicated for me, I need 3 cells J2, K2, and L2 to pull in the average number of days from the Q column excluding cells with no value, as not all cells are filled, AND for cells in column D4-D44 there are three typles of values there "CONNIE" "CECI" "TILLIE"

For cell J2, I need a formula for for the average of Q4-Q44, excluding zero value, and equal to "CECI" between columns D4-D44

For cell K2, I need a formula for for the average of Q4-Q44, excluding zero value, and equal to "TILLIE" between columns D4-D44

For cell L2, I need a formula for for the average of Q4-Q44, excluding zero value, and equal to "CONNIE" between columns D4-D44

That would give me the average processing times for each processor after a loan has closed unless you know of an easier way. I have attached an example of one of the sheets I am using

[Pete_UK]

Put this in J2:

=AVERAGEIFS($Q$4:$Q$44,$D$4:$D$44,"Ceci")

then copy it into K2 and L2 and just change the name at the end each time.

AVERAGE will ignore cells that are empty.

Hope this helps.

Pete

[FinGhost]

Thank you for the quick reply Pete, I tried to input that formula and its not taking it

[FinGhost]

I think I got it to work, I had an Extra space in there

[FinGhost]

can you help me with this part:

I have already put in line by line the =Nx-Ax to get the processing days (If someone could help me with a formula auto fill commands to do Q=N-A line by line instead of manually doing it that would be great).

[Pete_UK]

I don't understand what you mean. You have this formula in Q4:

=N4-A4

and that has been copied down, so what is the problem?

Pete

[XOR LX]

Ah! Perhaps he didn't realise that you could copy down the top formula in a range...and so actually inputted them all manually one by one: =N4-A4, =N5-A5, ...

Ouch!