Sourdough123
Board Regular
- Joined
- Oct 25, 2021
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ||||||||||
2 | ||||||||||
3 | ||||||||||
4 | Job Name | Date | Material | Job Value | Cost | |||||
5 | Superior Cabinets | July-22 | Atlas Nimbus | 42,767.00 | 25,036.61 | |||||
6 | Superior Cabinets | August-22 | Bianco Calacatta | 49,873.00 | 37,555.20 | |||||
7 | Superior Cabinets | August-22 | Calacatta | - | - | |||||
8 | Superior Cabinets | August-22 | Charcoal Grey | 86,633.00 | 58,170.12 | |||||
9 | Superior Cabinets | September-22 | Charcoal Grey | 115,509.00 | 77,738.85 | |||||
10 | Superior Cabinets | October-22 | Charcoal Grey | 130,075.00 | 90,477.66 | |||||
11 | Superior Cabinets | November-22 | Sparkle | 22,080.00 | 12,557.33 | |||||
12 | Superior Cabinets | October-22 | Concrete Grey | 115,508.00 | 81,036.80 | |||||
13 | Superior Cabinets | October-22 | Crystal White | 21,608.00 | 5,659.84 | |||||
14 | Superior Cabinets | November-22 | Concrete Grey | 411,112.00 | 286,745.60 | |||||
15 | Superior Cabinets | November-22 | Charcoal Grey | 338,195.00 | 208,729.10 | |||||
16 | Superior Cabinets | December-22 | Charcoal Grey | - | - | |||||
17 | Total | 537869 | 1,333,360.00 | 883,707.11 | ||||||
18 | ||||||||||
19 | ||||||||||
20 | ||||||||||
Sheet1 |
=DROP(REDUCE(0,UNIQUE(TAKE(L5#,,1)),LAMBDA(x,y,LET(s,FILTER(L5#,TAKE(L5#,,1)=y),VSTACK(x,s,HSTACK("Total",IFERROR(BYCOL(DROP(s,,1),LAMBDA(z,SUM(--z))),"")))))),1)
This is formula for above but i dont want date column summed
can you give hand please
Thanks