Spreadsheet: 869431d1715994785-formula-to-calculate-sales-data-as-per-conditions-sorted-values
Sheet: Sheet1

e | Date | Discription | Po# | File Count | Order Placed By | Order Type | Stitches | Amount | Status | Currency | Sales Rep | A Number | Comment
105 | 2023-09-25 00:00:00 | TERRIFIC Inc |  |  | [NAME] | artwork |  | 50
 | 105-09-23 |  |  |  | [NAME]) | [NAME])
105 | 2023-12-01 00:00:00 | Ramjay Inc. Logo |  |  | Prathap Jayaraman | artwork |  | 4.95
105 | 2023-12-07 00:00:00 | 3 Tea Labels |  | 3 | Prathap Jayaraman | artwork |  | 14.95
105 | 2023-12-12 00:00:00 | MGM photoshop |  |  | Prathap Jayaraman | artwork | photoshop | 24.75
105 | 2023-12-13 00:00:00 | Heart Image | PRATHAP |  | Prathap Jayaraman | artwork | photoshop | 19.8
105 | 2023-12-24 00:00:00 | Shastra business card |  |  | Prathap Jayaraman | business card |  | 19.95
 | 105-12-23 |  |  |  | artwork----4(300%)-amt64.45(28.9%) | [NAME]) |  | 84.4 | here it should not calculate as previous month is 9(sep23)
105 | 2024-01-18 00:00:00 | Shasthra Security T-shirts |  | 2 | Prathap Jayaraman | artwork |  | 16.85
105 | 2024-01-18 00:00:00 | Commercial Lynks Polo T-Shirts |  |  | Prathap Jayaraman | artwork | 11.98+4.95 | 16.93 | has to select range each time for month wise increase/decreased calculations of sales by particular type
105 | 2024-01-18 00:00:00 | Commercial Lynks Polo T-Shirts #2 |  | 4 | Prathap Jayaraman | artwork | 11.98+4.95 | 16.93 | (done using SUMIFS and COUNTIFS)
105 | 2024-01-18 00:00:00 | Shastra business card | NEW |  | Prathap Jayaraman | business card |  | 23.85
105 | 2024-01-24 00:00:00 | New T-shirt Design |  |  | Prathap Jayaraman | artwork |  |  | formula should only work if client Id is same & MM-YY is previous month(using TEXT() and VALUE())
105 | 2024-01-30 00:00:00 | [NAME] and a sign |  |  | Prathap Jayaraman | artwork |  | 34.65
105 | 2024-01-31 00:00:00 | Security Booth Render |  |  | Prathap Jayaraman | artwork | 4.95+4.95 | 9.9 | Also someway to select the range automatically for SUMIFS and COUNTIFS,
105 | 2024-01-31 00:00:00 | TERRIFIC INC.(Letterhead and Envelope) |  |  | Prathap Jayaraman | artwork |  | 89.95
 | 105-01-24 |  |  |  | artwork----7(75%)-amt185.21(187.37%) | [NAME]) |  |  | so even after insertion/deletion of NEW record, range gets adjusted accordingly
105 | 2024-02-01 00:00:00 | Commercial Lynks Polo T-Shirts |  |  | Prathap Jayaraman | artwork | 4.95+9.9 | 14.85
105 | 2024-02-01 00:00:00 | TERRIFIC INC.(Letterhead and Envelope) - p order |  |  | Prathap Jayaraman | artwork |  | 59.95
105 | 2024-02-13 00:00:00 | Windows graphic | RUSH |  | Prathap Jayaraman | artwork |  | 49.95
105 | 2024-02-14 00:00:00 | Window Frost Design |  |  | Prathap Jayaraman | artwork |  | 4.95
105 | 2024-02-16 00:00:00 | Now Leasing Sign with a Graphic |  |  | Prathap Jayaraman | artwork |  | 4.95
 | 105-02-24 |  |  |  | artwork----5(-28.57%)-amt134.65(-27.3%) | [NAME])
105 | 2024-04-01 00:00:00 | Booth |  |  | Prathap Jayaraman | artwork |  | 5.95
105 | 2024-04-02 00:00:00 | Diana/ stand and cards | Diana_Boutique_style |  | Prathap Jayaraman | Business card |  | 23.8
105 | 2024-04-11 00:00:00 | trailer design |  |  | Prathap Jayaraman | artwork |  | 59.95
105 | 2024-04-19 00:00:00 | Diana/ stand and cards |  |  | Prathap Jayaraman | artwork |  | 14.95
 | 105-04-24 |  |  |  | artwork----3(-40%)-amt80.85(-39.96%) | [NAME]) |  |  | here it should not calculate as previous month is 2(feb24)
106 | 2023-09-01 00:00:00 | Xotic Life |  |  | [NAME] | digitizing | 5954 | 11.85
106 | 2023-09-01 00:00:00 | Spring left chest dst |  |  | [NAME] | digitizing | 6665 | 13.26
106 | 2023-09-06 00:00:00 | JEnKINS |  |  | [NAME] | digitizing | 10945 | 21.78
106 | 2023-09-14 00:00:00 | DEBBIE |  |  | [NAME] | digitizing | 883 | 1.76
106 | 2023-09-14 00:00:00 | PASTOR A, D, Bell |  |  | [NAME] | digitizing | 2242 | 4.46
106 | 2023-09-14 00:00:00 | [NAME] |  |  | [NAME] | digitizing | 2431 | 4.84
106 | 2023-09-14 00:00:00 | DESSARAY |  |  | [NAME] | digitizing | 2653 | 5.28
106 | 2023-09-14 00:00:00 | Po-# binary |  |  | [NAME] | digitizing | 2653 | 5.28
106 | 2023-09-15 00:00:00 | [NAME] | 3599 |  | [NAME] | digitizing | 8893 | 17.7
106 | 2023-09-28 00:00:00 | 4inh |  |  | [NAME] | digitizing | 23607 | 46.98 | here it should not calculate as previous ID is 105
 | 106-09-23 |  |  |  | artwork----0(-100%)-amt0(-100%) | digitizing----10(NA%)-amt133.19(NA%)