search

klaudyu / CalcCraft

have formulas in tables like in excel: a1+a2, sum(), etc.
Apache License 2.0
46 stars 1 forks source link

Conditional sums? #5

Open hinnerk opened 9 months ago

hinnerk commented 9 months ago

Is there a way to make a sum depend on the value of different cell? Similar to SUMIF/SUMIFS/DSUM in Google Sheets?

klaudyu commented 9 months ago

It should be possible with something like =sum([a1:a5>5]*[a1:a5]), but I cannot test it right now, as the plugin is broken by the new release. They rewritten the table editor, so I have to see when I have time to recode the plugin for this.

davidszp commented 9 months ago

That is a pity, your plugin added a fantastic feature.