How to sum where another column is not blank
✓ Verified in LibreOffice 25.8.7.3Total only the rows that have something in a companion column — completed, dated, assigned.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =SUMIF(A2:A6,"<>",B2:B6) | "<>" alone means "not empty". The inverse (only blanks): =SUMIF(A2:A6,"",B2:B6). |
| Google Sheets | =SUMIF(A2:A6,"<>",B2:B6) | Identical. |
| LibreOffice Calc | =SUMIF(A2:A6,"<>",B2:B6) | Identical. |
How it works
The bare "<>" criterion matches any non-empty cell, so only rows whose A-column is filled contribute: 100 + 25 + 10 = 135, while the amounts beside empty cells are skipped. Handy for "sum only invoiced items" (date column filled) or "only assigned tasks". One caveat: a formula returning "" looks blank but counts as NOT blank here — filter on the underlying condition instead when your status column is formula-driven.
Verified, not just documented
We ran =SUMIF(A2:A6,"<>",B2:B6) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 135 — exactly the expected result. Every formula here is confirmed by actually executing it.