Sum returns value 0 [closed]

asked 2013-08-13 17:44:06 +0200

the_nookie gravatar image

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...

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 22:00:26.431192


Are the LOOKUP formulas returning zero?

w_whalley gravatar imagew_whalley ( 2013-08-13 19:06:37 +0200 )edit

Where is the sum function?

L-user gravatar imageL-user ( 2013-08-14 07:01:29 +0200 )edit