Okay right now I've get my SUMPRODUCT working great to get me an overall sum using the formulat below:
=-SUMIF(Table__Transact[DateStamp],"<="&DATE(E2,C2,D2),Table__Transact[TotalSale])+SUMIF(Table__Transact[DateStamp],"<"&DATE(J2,H2,I2),Table__Transact[TotalSale])
Now what I want to do is use this in conjunction with another range Table__Transact[ProductID] to only calculate the ones with the date range with a prodoct ID of "010".
Thanks for any help!
Bookmarks