how to write the sum+condition chart formula?

[sdtfll]

there are two columns:

column: group (some cells with value, but some without value and is null)

column: amount (numbers)

now want to sum the amount for group which the value is not null,

how to write the chart formula?

I tried like this but failed:

sum({isnull(group)=-1}amount)

[BrunPierre · Accepted solution]

Perhaps with Sum(IF()) expression or Set Analysis like this

Sum(IF(Not IsNull(group),amount))

or

Sum({$<group={"=Len(Trim(group))=0"}>} amount)

[sdtfll]

Thanks so much!

[Alagumurugan]

Hi @sdtfll,
Please Structure the formula correctly. It will work.

Thanks,
Murugan