sum if cells have value if there is no value leave it blank

[Prasad K]

sum if cells have number value & if there is no numbers in cell then leave it blank cell

Create Folder and Sub Folders.xlsm
	A	B	C
1	Test-U	Test-B	Total Sum
2	2	1	3
3		2	2
4	3	2	5
5	1		1
6			0
7		1	1
8			0
9	2	4	6
10	1		1
Sheet2

Cell Formulas
Range	Formula
C2:C10	C2	=SUM(A2:B2)

 

[Michael M]

Try
=IF(AND(A2="",B2=""),"",A2+B2)

 

[Prasad K]

Try
=IF(AND(A2="",B2=""),"",A2+B2)

Thank you sir & one more small help can we do with any vba

 

[Michael M]

Seems a bit pointless really

Sub MM1()
With Range("C2:C10")
    .Formula = "=IF(AND(A2="""",B2=""""),"""",A2+B2)"
    .Value = .Value
End With
End Sub

 

[Prasad K]

Seems a bit pointless really

Sub MM1()
With Range("C2:C10")
    .Formula = "=IF(AND(A2="""",B2=""""),"""",A2+B2)"
    .Value = .Value
End With
End Sub

what do mean we can't ask a question like this

 

[Michael M]

No I mean that using VBA to carry out a native Excel function seems pointless
The formula can be inserted in 1 cell to apply to ALL other cells in the column......why use VBA to do the same thing

 

[Prasad K]

No I mean that using VBA to carry out a native Excel function seems pointless
The formula can be inserted in 1 cell to apply to ALL other cells in the column......why use VBA to do the same thing

yes your correct & why i asked for vba if i apply formula in cell and when i edit that cell it will display formula if i apply with vba then it's never display formula in cell when i edit that cell

and i am sorry for my previous reply to you

once again thank you much for your help

 

[Michael M]

No need for apologies....I simply didn't want you to have to use VBA if it wasn't necessary...