Count / Avg Function

[Alma]

I am working on a Productivity Log and can't figure out a way to count unique values, and also average the time per assignment.

Assignment with the action code A - should take 2 hrs to complete, all other action codes should take 20 minutes.

I need to show how many of each action codes were done for the day, and what was the average time taken to complete each. Even better, how much for A action codes, and how much for all other.

Please see the example attached.

Thank you for your time

[DonkeyOte]

Based on your sample file, my interpretation of your requirements, and assuming you're not running XL2007...

G60: =SUMIF(F10:F59,"A",G10:G59)
G61: =SUM(G10:G59)-G60

G63: =G60/COUNTIF(F10:F59,"A")
G289: =G61/SUM(COUNTIF(F10:F59,{"P","C","O"}))

note: I'm not sure why G289 is not G64 (ie for Monday)

[ChemistB]

In G60 using SUMIF(Range,Criteria,SumRange)

=SUMIF(F10:F22,"A",G10:G22)

In G61 assuming all other codes are either P,C or O

=SUM(G10:G22)-G60

In G63, using the previous SUMIF result in G60 and COUNTIF

=G60/COUNTIF(F10:F22,"A")

and in G64

=G61/(COUNTIF(F10:F22,"P")+COUNTIF(F10:F22,"C")+COUNTIF(F10:F22,"O"))

Is that what you are looking for?

[Alma]

Thank you so much. It works perfectly!