sum if distinct condition

[PARK_JY]

hi,

I wrote below th use sum, if, distinct function in sheet to make a graph.

=if(Month='Dec' and Name='Jay', distinct(sum(Inf))

but, it is not working.

How should i modify the above sentence?

[sidhiq91 · Accepted solution]

@PARK_JY  You could use a set expression like below to get the desired output:

sum({<Month={'Dec'}, Name={'Jay'}>}distinct inf)

Please let me know if this resolved the issue.

[PARK_JY]

Thank you:)!!