Need help with Average function

[scarames]

I've tried so many different ways, but I'm not able to get the same answer enough to be comfortable. I'm using Excel 2007.

I've got a spreadsheet that I do every month with columns of numbers that I average. This sheet has to match about 10 others similar. The columns are divided by Weekdays, Saturdays, Sundays. But some months there are no entries for certain cells on Saturday or Sunday. I thought that if I just used the Average function, it would dismiss and not count the blank cells. Alas, apparently not. I've highlighted in yellow the one column that I'm really having trouble with. If anyone could be of assistance, I'd be very grateful.

[NBVC]

Try:

=AVERAGE(IF(F7:F40<>"",F7:F40))

this formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER...you will see {} brackets appear around the formula...

then you can copy left/right

[scarames]

Worked great! Thank you SO much!

[scarames]

Just a simple question, I've not heard of the Crtl-Shift-Enter. Just what exactly does that do?

[NBVC]

Just a simple question, I've not heard of the Crtl-Shift-Enter. Just what exactly does that do?

It is how Excel evaluates Array Formulas...

see here for more information....

http://www.cpearson.com/excel/ArrayFormulas.aspx

[scarames]

By evaluating, do you mean confirming, or verifying that it's correct? Thanks for all your replies.

[NBVC]

By evaluating, do you mean confirming, or verifying that it's correct? Thanks for all your replies.

I mean how it comes up with the answer... i.e. creating arrays and evaluating each the conditions...

[scarames]

NBVC, Could you mark the post solved for me please? Thanks

Scarames