In excel I have macro to sum cells by background (manually set doing analysis) I understand that is not possible in o/calc. However nearly everything else, any ideas. I appreciate there is way around by having separate column with related reference to sum by, but not having to set that up would avoid confusion for others, using the w/book.
thank you
