Hi, unsure if I'm going about this the wrong way.
I'd like to SUM a column where the first column has a certain day. The first column is stored as a date, although displays as a day using the Number format of 'dddd', and the values I need to SUM are displayed in different columns depending on the time of day. I thought a VLOOKUP would work so that I could determine which column I need to SUM, but I cannot get the day bit to work.
My hope was:
=SUM(VLOOKUP(2,August!A5:R35,16))
My problem is I don't know how to make the '2' bit be a weekday value. My understanding of VLOOKUP is basic, so small words would help
Am I going about this the wrong way? I've attached a sample workbook. In my real example, the only sheet I'll be able to change is the "Analysis" one as it will be in an external workbook.
Cell F10 in Analysis is my play cell.
Any suggestions, even if the suggestion is "don't use VLOOKUP" would be greatly appreciated.
DoorStats_2015.xlsx
Bookmarks