Adding Cells that Correspond to Days

[aje35]

I have a column of dates and a corresponding column of price. I want to add the prices that go with Mon-Fri Dates but not Weekends. I know the WEEKDAY() Function however I don't know how to add cells that go with a WEEKDAY() Output of <6. I am trying to avoid the M word (Manual). Any insight would be appreciated.

 

[Ruddles]

Assuming you have a date in A1, then =MOD(A1,7) will return 0 for a Saturday and 1 for a Sunday.

If you have a coresponding price in B1, then =IF(MOD(A1,7)>1,B1,"") will return the value in B1 if A1 is a Saturday or Sunday, otherwise it will set the cell to blank. (You would put this in C1, perhaps.)

Is that the sort of thing you were looking for?

 

[aje35]

This is definetly a way I hadn't looked at it. I am looking for a solution that can be applied in to a SUM or SUMIF function. Like SUMIF(A:A,"when value in same row but column X is less than 6). More specifically what I am dealing with is a month of prices and I only want to add the prices that correspond to weekdays. If I can clarify further please let me know.

 

[aje35]

Figured it Out

If my dates are in Column A and my prices are in Column B then I insert Workday(A1,2) and drag that over Column C. Then I put a =SUMIF(C:C,"<6",B:B) in an arbitrary cell and that returns the Sum of Monday thru Friday prices only. Thank you for your help!