Looking for excel/open office guru
I have what I think is a relatively simple programming question about spreadsheets. The solution needs to work in both open office and excel.
What I want to do is tag a cell such that it can be summed in two different ways. I have an array of cells which contain either a formula or are blank The formula is copied and pasted into all the relevant cells by the user. I need the total number of cells which have formulas, and the total of all the values in the cells. This works fine. Now I would like to another category which will be subtotaled for both having a formula and total values. I tried to use color, but couldn't get it to work. The key stumbling block seems to be getting the information into the formula. If it matters, the formula only produces integers in the 1-4 range, and they don't need to be user understandable (so, for example, using 5-8 for the second set would be an option).
If anyone has any thoughts, I would be most grateful. Barter is available (homemade beer or jam?)
What I want to do is tag a cell such that it can be summed in two different ways. I have an array of cells which contain either a formula or are blank The formula is copied and pasted into all the relevant cells by the user. I need the total number of cells which have formulas, and the total of all the values in the cells. This works fine. Now I would like to another category which will be subtotaled for both having a formula and total values. I tried to use color, but couldn't get it to work. The key stumbling block seems to be getting the information into the formula. If it matters, the formula only produces integers in the 1-4 range, and they don't need to be user understandable (so, for example, using 5-8 for the second set would be an option).
If anyone has any thoughts, I would be most grateful. Barter is available (homemade beer or jam?)