Add an extra column (e.g. C) entitled Closed, and put 1 next to each job closed.
Better: Use the title Open, and put 1 next to each job open, and 0 next to each job closed. Use =COUNT(C4:C15
) or =COUNT(A4:A15)
to for the Total Jobs, =COUNTIF(C4:C15;"0")
for the Total Closed Jobs, and =SUM(C4:C15)
for the Remaining Job count.
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→
) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow (
) that is on the left (to vote, you need to have karma of at least 5).
Isn't this just a COUNTCOLOR() or COUNTIF(...;color) in disguise?
The one valid response to all the questions of this kind -though not an answer, but an advice- was and is: Don't code information you want to evaluate later by setting attributes!!!!
Do as @LeroyG suggests, and you can in addition get the strikeout by ConditionalFormatting.
(As compared with variants using background colors, strikeout -or any character attribute- is even worse, because it will be invisible as soon as the cell no longer shows a content or result, but will still be present as a cell attribute. In addition it may be unclear to unexperienced users, that the attribute will NOT be detected by means like the macro also discussed here, if only "most of the content" has it. The cell asked for
oCell.CharStrikeout
e.g. will not know about it then. Don't do it!!)