It's quite a pain learning new features of Excel but once we get the hang of how they operated, they're a tremendous tool in quickly making our tasks done. Do not include the dates in the range to be consolidated because it reads the dates as numbers resulting in total values.