Hello All,

I've searched for a solution but I can't make the answers to similar threads work for me.

I want to use sumproduct on date columns (and sometimes date and numerical columns and/or text) and I want the formula to treat the data in those columns as a dynamic range (with constantly changing outer ranges), but I have headers and they have to stay. The data is not in a table format and there are no named ranges. The reason for this is we merge several workbooks periodically and the named ranges, etc. mess up the merging.

The formula I use is this:

=SUMPRODUCT((MONTH(ProductMaster!$A$2:$A$250)=2)*(YEAR(ProductMaster!$A$2:$A$250)=2017)*((ProductMaster!$A$2:$A$250)>3))

and I want the ProductMaster!$A$2:$A$250 to be treated as a dynamic range to exclude headers.

Is this even possible?

Thanks

Zeda