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
Bookmarks