Skip to content

Instantly share code, notes, and snippets.

@Omid-M22
Created February 13, 2022 22:29
Show Gist options
  • Save Omid-M22/7fc1d6defa8b2fac90dd66ce55591014 to your computer and use it in GitHub Desktop.
Save Omid-M22/7fc1d6defa8b2fac90dd66ce55591014 to your computer and use it in GitHub Desktop.
Easily extraction of sum (or average or min or .....) of data based on special column in excel by Lambda function
Extract_sum_of_Criteria= LAMBDA([Criteria column], [numerical column],
IF(
ISODD(
SEQUENCE(
COUNTA(
UNIQUE(
[Criteria column]
)
),
2
)
),
UNIQUE(
[Criteria column]
),
SUMIFS(
[numerical column],
[Criteria column],
UNIQUE(
[Criteria column]
)
)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment