I have a calc spreadsheet I need help with. I’ve googled and googled and can’t find a solution, although that may be because I’m somewhat technologically inept.
I have highlighted (the background fill colour of the cell) monetary amounts according to a Key for a personal finance spreadsheet. For example, the cell containing daily amounts for expenditure on food is highlighted in red.
Rather than going through every red cell and adding up the amounts (i.e. =SUM(C76+812)) I would like to be able to do a sum where it adds up all of the cells which are highlighted in red.
I tried the advice on the following links:
I even tried (and failed) to create a ‘macro’ to help me do this (I’m not sure what a macro is). And now I don’t know how to remove the macro, so I’d also like help with this…
And I can’t get anything to work. I’m sure there must be a way around this so would really appreciate some help. Also if you could explain it very simply and give a step-by-step that very much appreciated!
I’m using LibreOffice version 22.214.171.124 on a Mac laptop, Operating system 10.13.6 and the document is .ods .