Count / Avg Function

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

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)

In G60 using SUMIF(Range,Criteria,SumRange)

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

and in G64

Please Login or Register  to view this content.

Is that what you are looking for?