S

#### sandres74

- 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.

Here's my question:

If I want to have the sum of all sales made ONLY on Mondays for the entire

year to appear in a cell (let's say cell F1), what would the formula have to

be?

In other words, how can I get Excel to calculate the sum of ONLY the numbers

listed in column C which have the word 'Monday' written in the same row of

column B?

I hope I explained that clearly! Thanks in advance!