You can use SUMIF and COUNTIF to find your averages, as such:

Assuming your data is in A1:B13 use this formula to find the Average:

=SUMIF(A1:A13,"=DAY*",(B1:B13))/COUNTIF(A1:A13,"=DAY*")

and this give the total of all of the days:

=SUMIF(A1:A13,"=DAY*",(B1:B13))

Of course modify your ranges to meet your needs.

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=385228