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!