Code: Select all
=SUMIF(I3:17,'S',G3:G7)
Code: Select all
=SUMIF(I3:17,'S',G3:G7)
Code: Select all
=SUMIF(I3:17;"=S";G3:G7)
Both gives the same result in 99.99% of cases.RoryOF wrote:I didn't need the = sign. Try both with and without it.
Code: Select all
=SUMIF(A1:A5;"<20";B1:B5)
Code: Select all
=SUMIF(A1:A5;"=<20";B1:B5)
I know I am off topic, it was just about the use (misuse) of = sign in SUMIF/COUNTIF.RoryOF wrote:@gerard24: the original question was matching a character in the first column, not a number.
gerard24 wrote:So, the = sign is unnecessary.
Code: Select all
=SUMIF($A$1:$A$5;"<=20";$B$1:$B$5)
All right, so i put in the equals sign and double quotes. I tried the semicolon, but they keep getting changed back to commas. In any case, it still gives me the same error. I assume this is a variation between OOo and LibreOffice? This is the my first time with LO, should i take this issue to them??robleyd wrote:TryCode: Select all
=SUMIF(I3:17;"=S";G3:G7)
Code: Select all
=SUMIF(I3:17,"=S",G3:G7)
Doctor J wrote:All right, so i put in the equals sign and double quotes. I tried the semicolon, but they keep getting changed back to commas.
We are dealing with LibreOffice and English user interface. It accepts the semicolon but replaces them with comma. Semicolon is the true separator which is saved in the document but LibreOffice with English user interface uses the comma due to all the English Excel experts which is why the semicolon is "translated" to a comma for the user interface only.RoryOF wrote:Always good to have all aspects of a problem discussed.