Hello,

I've just joined in order to ask this question, so thank you all in advance for listening.

My sum range, criteria range 1, criteria 1 are all good to go. The problem comes in when I try to add another criteria range and criteria in order to narrow the results down to last 6 months. Because I do not want to explain to my boss how to fiddle with dates - I wanted to incorporate the TODAY function into the SUMIFS function. My range is the ship date and my criteria should be last 6 months of dates.

Is what I am trying impossible? Should I give up and use a helper cell instead? Thanks in advance!excel today capture.PNG