Ask Your Question

the_nookie's profile - activity

2017-11-21 17:23:42 +0200 received badge  Student (source)
2017-01-01 22:47:44 +0200 received badge  Taxonomist
2013-11-12 15:20:52 +0200 received badge  Famous Question (source)
2013-10-17 20:23:04 +0200 received badge  Famous Question (source)
2013-10-04 20:24:38 +0200 received badge  Notable Question (source)
2013-10-04 20:24:38 +0200 received badge  Popular Question (source)
2013-08-17 08:32:34 +0200 asked a question How to extract element from string

I want to extract the elements in a specific position in a stsring and to put them in cells in a diferent sheet. They are separated by interval.

this is the excel function which makes it =ExtractElement(A1,1,".")

2013-08-16 14:13:20 +0200 received badge  Notable Question (source)
2013-08-13 22:42:15 +0200 received badge  Popular Question (source)
2013-08-13 17:44:06 +0200 asked a question Sum returns value 0

I just want to sum a column with cells like =LOOKUP(D44;$Sheet1.$A$5:$BZ$5;$Sheet1.$A$95:$BZ$95) =LOOKUP(D45;$Sheet1.$A$5:$BZ$5;$Sheet1.$A$95:$BZ$95)

etc. and it returns zero Obviously it doesnt recognise the data as numbers, but I don't understand why. The number format is general...