While the first formula is good, the second formula for earlier versions
doesn't ignore zero values. Could do:

=SUMIF(B:B,"MONDAY",C:C)/SUMPRODUCT(--(B$1:B$365="MONDAY"),--(C$1:C$3650))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rslaughter5" wrote:

Use AVERAGEIFS(C:C,A:A,"Monday",C:C,"0"). If you do not have Excel 2007, use
SUMIF()/COUNTIF() together.

"sandres74" wrote:

Here's a description of spreadsheet that I am making for the sales of a sto

- Column A has all the dates of the year (January 1, January 2, January 3,
etc.) for the entire year listed one after another (so a total of 365 rows,
starting in row 1).
- Column B has the day of the week (Monday, Tuesday, Wednesday, etc.)
corresponding to the date next to it in column A.
- Column C has the sales amount (example: $125.50) corresponding to the
date/day listed in the same row of columns A and B.

I have the following formula (which works great) which gives me the SUM of
all sales made ONLY on MONDAYS for the entire year to appear in a cell:
=SUMIF(B:B,"MONDAY",C:C)

My question is:
Is there a formula that would allow Excel to calculate the AVERAGE
(excluding blank cells and cells with zeros!) of all sales made ONLY on
MONDAYS for the entire
year? I have tried to modify the formula above to do that, but to no avail.
I know not what I am doing! Can anyone help?

Thanks in advance!