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

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

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

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’)