Lambda function sum columns

Status
Not open for further replies.

Sourdough123

Board Regular
Joined
Oct 25, 2021
Messages
142
Office Version
  1. 365
Platform
  1. Windows
Book1
ABCDEFGH
1
2
3
4Job NameDateMaterialJob ValueCost
5Superior CabinetsJuly-22Atlas Nimbus42,767.0025,036.61
6Superior CabinetsAugust-22Bianco Calacatta49,873.0037,555.20
7Superior CabinetsAugust-22Calacatta--
8Superior CabinetsAugust-22Charcoal Grey86,633.0058,170.12
9Superior CabinetsSeptember-22Charcoal Grey115,509.0077,738.85
10Superior CabinetsOctober-22Charcoal Grey130,075.0090,477.66
11Superior CabinetsNovember-22Sparkle22,080.0012,557.33
12Superior CabinetsOctober-22Concrete Grey115,508.0081,036.80
13Superior CabinetsOctober-22Crystal White21,608.005,659.84
14Superior CabinetsNovember-22Concrete Grey411,112.00286,745.60
15Superior CabinetsNovember-22Charcoal Grey338,195.00208,729.10
16Superior CabinetsDecember-22Charcoal Grey--
17Total5378691,333,360.00883,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
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Please stop duplicating your questions. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

If you do not receive a response, you can "bump" your original thread it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,215,943
Messages
6,127,820
Members
449,409
Latest member
katiecolorado

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top