I'm glad it worked for you. Sorry about my dyslexic Sumif function.

--
Regards,
Fred


"David" wrote in message
...
Fred Smith wrote

You should be able to use Sum/Count, as in:

=sumif(C:C,"AM",A:A)/countif(A:A,"AM")


I had to change it to:
=SUMIF(A:A,"AM",C:C)/COUNTIF(A:A,"AM")
changing "AM" to "PM" for second forumla

I chose your solution because the range will grow.
Many thanks.

--
David