Hello can someone help me, how can sum range of cells

User Support Form Building
1

i have tried this syntax but not working, sum(${B}[15:38])
I want to get all the yes no value added in this range and use them for my calculation

2

Welcome to the community, @muhixx! You should be able to learn more about sum here.

3

thank you @Kal_Lam
can you help me with how to write ‘do nothing’ in if statement when the condition is not true?
example if ( condition, ‘do an action’, ‘do nothing’)