Hello,
Please find attached an example file.
In reference to my question mentioned in the post title:
"How to get total price with multiple criteria based on (ORDER NUMBER) and (DATE)?", I tried different functions and it went either ZERO or errors.
I would really appreciate your help in resolving the problem.
Thank you!
Yaser
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
Last edited by DBY; 12-06-2016 at 08:16 AM.
It is working fine and no problem!
I attached an updated version of corrections for RYZA and SHAS.
I very much appreciated; I really appreciate your help.
Last edited by yaseralhosani; 12-06-2016 at 11:25 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks