Calculating with numbers saved as text?

[Jaymond Flurrie]

Is it possible to calculate with numbers saved as text? Like for example a SUMIF-function so that the numbers to sum are saved as text?

Or is the only option to convert the text to numbers first, and then to calculate?

 

[Jaymond Flurrie]

To add on this, the numbers are nothing but numbers, so they are not like numbers and text. They are just saved as text. Besides of SUMIF, VLOOKUP would also help.

 

[Eric Golf]

Hi,

Using Value() will convert text to numbers in a formula. e.g. =Value(A1)+Value(A2)

Hope this helps,

Eric

 

[Jaymond Flurrie]

Hi,

Using Value() will convert text to numbers in a formula. e.g. =Value(A1)+Value(A2)

Hope this helps,

Eric

Doesn't seem to work like this:
=SUMIFS(value($G:$G);value($E:$E);"3040")
:/

edit. ; is the parameter separator in my locale.

 

[Peter_SSs]

For example, instead of
=SUMIF(B1:B6,"a",D1:D6)
try
=SUMPRODUCT(--(B1:B6="a"),--(D1:D6))

Avoid whole column references where possible.

 

[rlv01]

Don't forget the Evaluate function.

Debug.Print Evaluate("2+2") '=4


Dim S1 As String, S2 As String
S1 = "3"
S2 = "07"
Debug.Print Evaluate(S1 & "+" & S2) '=10

 

[Jaymond Flurrie]

For example, instead of
=SUMIF(B1:B6,"a",D1:D6)
try
=SUMPRODUCT(--(B1:B6="a"),--(D1:D6))

Avoid whole column references where possible.

I think this solved it, thanks

 

[Jaymond Flurrie]

With VLOOKUP, this seems to work:
=IFERROR(VLOOKUP(id,planets,3,0),VLOOKUP(id&"",planets,3,0))
https://exceljet.net/formula/vlookup-with-numbers-and-text

 

[Peter_SSs]

I think this solved it, thanks

You're welcome.