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!