Hello
In cell K11, for example, try:
Formula:
=SUMIFS(CALCULATOR[PRICE],CALCULATOR[ORDER NUMBER],J11&"*",CALCULATOR[DATE],">="&L11,CALCULATOR[DATE],"<="&EOMONTH(L11,0))
This returns $1,080.0 for February 2016, as your example. However, not sure how you reached the figures for RYZA and SHAS, as they have no values for February 2016. Is this an error?
DBY
Bookmarks