Want to Sum To cells . One Contain Text And other cell Contain Value

[nomi2565]

Want to Sum Two cells . One Contain Text And other cell Contain Value.
E.g A1= Nil And B1= 100
on adding them result comes in#Value where the results should be 100.


Please send me any additional sheets to learn Logical conditions & Formulae .

[oeldere]

I can't read PNG.

reading your question it would be using sumif.

or using pivot table.

[nomi2565]

thanks Oeldere,

Using Sumif or anything your goodself think is appropriate.

[TudyBTH]

Hi,
if "Nil" is an Defined Name use

Please Login or Register  to view this content.

Capture1.JPG
if nil represent "zero" put "0" in cel