ExcelBanter - sum formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sum formula (https://www.excelbanter.com/excel-discussion-misc-queries/220837-sum-formula.html)

ADIB

sum formula

please help for the following
A B C
20 5 15
30 30
50 20 30

i wand sum b1:c3 if c1:c3 have value it means b4 would be 25
Please suggest me how can i make formula for above
Thanks

All times are GMT +1. The time now is 12:25 AM.