What's the best way to reference tables in formulas? I'm attaching a file with a calendar type layout. What I want is the formula in B4 in the desired results sheet to tally up the number of ML for that week. I can get it working no problem with Countifs for the ML bit - it's referencing the date in the columns that I can't get to work...ideally then how to copy across that for the other weeks. Thanks.