Intermediate Excel Formula(s) Question?

I have two columns: column A is "Day of Week" and column B is "Sales".
I want to create a formula(s) that will search the "Day of Week" column for "Friday", take the matching "Sales" number in adjacent column B and include it in an average formula.
In other words, I would like to calculate the average sales for Friday as I continue to add data to column A over time.
I am aware that I can 'sort' this data by day of week and quickly get an average that way. However, I do not want to sort the data in this manner and prefer to have a formula do this work automatically.
Please help! Thanks.
James

Thanks for the responses! One more question. If I have the date (MM:DD:YY) in one column and need to convert that to a Date in another column, how can I accomplish this? Thanks!

Two ways to do this:

1) SUMIF/COUNTIF - this gets the total for all the Fridays, and then divides it by the number of Fridays found to get the average:

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

2) AVERAGE array function - this uses the Average function, but only includes rows where column A is "Friday". Input this using Ctrl-Shift-Enter, rather than just Enter:

=AVERAGE(IF(A1:A100="Friday", B1:B100, ""))

I hope this helps, but add more detail or e-mail if you need more info.
Good luck.
.

Let's say A1 and B1 are your column headings, and A2:B366 contains your sales data. You can use the formula:

=SUMIF(A2:A366,"Friday",B2:B366)
/COUNTIF(A2:A366,"Friday")



--
garfield-n-odie
Microsoft MVP 2005-2008
http://mvp.support.microsoft.com/