Spreadsheet: 869432d1715994785-formula-to-calculate-sales-data-as-per-conditions-sorted-formulas
Sheet: Sheet1

e | Date | Discription | Po# | File Count | Order Placed By | Order Type | Stitches | Amount
105 | 2023-09-25 00:00:00 | TERRIFIC Inc |  |  | [NAME] | artwork |  | 50
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
 |  |  |  |  |  |  |  |  | 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 |  | 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 |  | (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
 |  |  |  |  |  |  |  |  | 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 | 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
 |  |  |  |  |  |  |  |  | here it should not calculate as previous month is 2(feb24)
106 | 2023-09-01 00:00:00 | Xotic Life |  |  | [NAME] | digitizing | 5954
106 | 2023-09-01 00:00:00 | Spring left chest dst |  |  | [NAME] | digitizing | 6665
106 | 2023-09-06 00:00:00 | JEnKINS |  |  | [NAME] | digitizing | 10945
106 | 2023-09-14 00:00:00 | DEBBIE |  |  | [NAME] | digitizing | 883
106 | 2023-09-14 00:00:00 | PASTOR A, D, Bell |  |  | [NAME] | digitizing | 2242
106 | 2023-09-14 00:00:00 | [NAME] |  |  | [NAME] | digitizing | 2431
106 | 2023-09-14 00:00:00 | DESSARAY |  |  | [NAME] | digitizing | 2653
106 | 2023-09-14 00:00:00 | Po-# binary |  |  | [NAME] | digitizing | 2653
106 | 2023-09-15 00:00:00 | [NAME] | 3599 |  | [NAME] | digitizing | 8893
106 | 2023-09-28 00:00:00 | 4inh |  |  | [NAME] | digitizing | 23607 |  | here it should not calculate as previous ID is 105