"Sumif()" in Calc not working [closed]

asked 2014-02-25 16:16:12 +0100

Spike gravatar image

updated 2015-09-12 03:27:51 +0100

Alex Kemp gravatar image

Calaculation "=SUMIF($C$3:$C$46,"Yes",I$3:I$46)" does not work in a new spreadsheet, but worked ok in last year's copy.

if I try "=SUMIF(F31:F36,"SO",G31:G36)" then that works ok.

LibreOffice version: 4.1.4.2 running under Mac OS 10.6

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-19 15:07:27.268074

Comments

And "does not work" exactly means what?

erAck gravatar imageerAck ( 2014-02-25 16:20:51 +0100 )edit

It returns a zero value

Spike gravatar imageSpike ( 2014-02-25 16:33:48 +0100 )edit

Maybe you are comparing "Yes" as text with cell with 0 for false other number for true. Please what is the value in a cell with Yes (Not the format).

m.a.riosv gravatar imagem.a.riosv ( 2014-02-25 23:05:57 +0100 )edit