Long time reader but first time poster...

I have been searching everywhere for a simple solution to get the average fuel cost depending on which day of the week it is. In other word, how much does fuel cost on Mondays, Tuesdays, etc.

This is my unsuccessful attempt:

=SUMIF(A1:A100,"Monday", B1:B100)/COUNTIF(A1:A100,"Monday")

Where column A has dates and B has the prices I paid per gallon on that day.

I also tried using a 3rd column with just the day of the week (using =A1 and formating to return the day only) but no luck. #DIV/0! Using just SUMIF doesn't work either.

My problem I think is the day...

I am using Excel 2003.

Many thanks for all the help you have already given me,

Patrick