[Solved] SUMIF returning 0

[kineticviscosity]

Edit: turned out it was a stupid problem, there were white spaces after each number which meant even though it formatted the cells as numbers, Calc was unable to read them as such.

Hi,

I've spent a while trawling forums and help pages to try and solve this to no avail.

I have a spreadsheet with a column of numbers. Beside each number is its associated category. I want to total the numbers in each category.

For this task I picked 'SUMIF', =sumif(range;criteria;sum_range)

My range is the list of categories by each number, i.e. $F$20:$F$50
My criteria is a cell containing one of the categories, i.e. F2 - where F2 contains the word: Accommodation
My sum_range is the list of numbers to sum, i.e. $E$20:$E$50

Completed formula:

=sumif($F$20:$F$50;F2;$E$20:$E$50) - which returns 0

The formula result returns 0 and I can't understand why as from everything I've read this should work. If I put = before F2 in criteria it returns an error, i.e. =F2.

I've had a look at previous SUMIF questions but none seems to show a way to perform this fairly simple application. It's probably something stupid and if so I apologise but I can't find the problem.

[Villeroy]

menu:View>Highlight Values [Ctrl+F8]
Column "Qty" does not contain any numbers.
You entered these figures with a wrong decimal separator. Replace the points with commas.

[JohnSUN-Pensioner]

Welcome to the forum!
It's simple: the first column is not the number values.

menu:View>Highlight Values [Ctrl+F8]
Replace the points with commas

... and remove the spaces after the numbers