Macro program for sum

[Closed]
Report
-
Hello,

I need to find out a formula for sum for the following conditions
if (and(cell b1="text", cell b5="text",cell b10="text",cell b16="text")sum(c1+c5+c10+c16,or blank)

Can you able to develop a programme for my above formula in macros