How can I write a conditional SUM formula to get these totals.

If A2 has some value then it should SUM the values as =SUM(A2*C2) if A2 has "0" then
it should calculate SUM as =SUM(B2*C2).

What is the code for this one, please.

Attached Images

If Calculation.PNG (5.9 KB, 25 views)

A2*C2 is a product. Why would you want to sum a product?
In your example the SUM function is not necessary
try =If(A2,A2*C2,B2*C2)
As you have posted in the programming section, do you need a VBA solution?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thaks for your kind reply. It's working fine. VBA code would be more useful.

I can give you a VBA solution but you'll need to supply more information, like what you have in mind to trigger the macro ?