Average help!

[JGARDNER-AIT]

Hello - I'm trying to average a users project turn times once it completed.
I have a spreedsheet of data indicating multiple users names in column "L".
The code "Complete" in column "C". Thier turn time is in column "AS" by project.

How can I get one average number for everythiung they have completed into one cell?

Thank you,
Josh

 

[Scott Huish]

=AVERAGE(IF(C1:C1000="Complete",AS1:AS1000))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

If you need it for a specific name, then:

=AVERAGE(IF(L1:L1000="Joe",IF(C1:C1000="Complete",AS1:AS1000)))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

 

[JGARDNER-AIT]

I'm getting #NUM!. Is it because in column "AS" its formulas and theres text and numbers?

Heres an example formula:
IF(C4147="","NOT STARTED",IF(C4147="HOLD","HOLD",IF(C4147="PENDING","PENDING",IF(C4147="OFQ","OFQ",IF(C4147="REVIEW","REVIEW",IF(C4147="CLOSED","CLOSED",IF(AND(C4147="COMPLETE",K4147=""),NETWORKDAYS(M4147,W4147)-AT4147,NETWORKDAYS(M4147,W4147)-AT4147)))))))

=AVERAGE(IF(C1:C1000="Complete",AS1:AS1000))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

If you need it for a specific name, then:

=AVERAGE(IF(L1:L1000="Joe",IF(C1:C1000="Complete",AS1:AS1000)))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

 

[Scott Huish]

You asked for an average, where are the numbers you want to average?

BTW, the first part of that formula could be greatly simplified.

 

[JGARDNER-AIT]

Its coming from the networkdays formula.

You asked for an average, where are the numbers you want to average?

BTW, the first part of that formula could be greatly simplified.

 

[Scott Huish]

=AVERAGE(IF(L1:L1000="Joe",IF(C1:C1000="Complete",IF(ISNUMBER(AS1:AS1000),AS1:AS1000))))

Confirm with CTRL-SHIFT-ENTER rather than just Enter