# Bug in my sumif() regex [closed]

I have a calc spreadsheet with an attempt at a sumif expression that I haven't been able to get right. The expression I have coded is: =SUMIF(B6:B93,"=*",(D6:D93)-(C6:C93)) and here is a sample of four rows of data in columns B-D:

```
B C D
* (blank) $200.00
$170 $100.00
* $150 $600.00
* (blank) $300.00
I expect this to return $950, but I end up with #VALUE!
```

Please post if you can spot my error. Thanks!

Where's the "regex"?

BTW:

The comma used as as the parameter delimiter conflicts with the decimal delimiter for the majority of locales. Better use the semicolon. (See https://ask.libreoffice.org/en/questi....)

Thanks, Lupp. I originally wrote the expression with semicolons, and then LO changes the ;'s to ,'s...

This is default in locales with the comma being the decimal separator for some time now. You can change the setting in

`>Tools>Options>LibreOffice Calc>Formula>Separators>Function`

.