Worksheet Function

[uday]

Hi all,

I am trying to sum all value from A to C category in the Total column by rows. Now, if Column A has value then the only sum function should applied in the Total column.
Otherwise, it should remain empty.

I have attached the sample file herewith.

 

[Hui]

F2: =IF(A2<>"",SUM(B2:D2),0)
Copy down

then Custom Format Column F2:F10 as 0.00,-0.00;;

 

[uday]

Thanks for the reply, Sir. However, I want VBA to job done.