Hi There!
I have some excel problems I was hoping to get advise on. Any help is appreciated
Please ask any questions needed for clarification, I've outlaid the problem as best I can below:
The purpose of this table is to cross reference and analyse data
Rules
> Every Column in the table will be totalled and analysed in the Trial Tally Box (B463-467)
However I would like to be able to change and filter which columns get their data inputed for the purpose of analysis
I would like to do this by checking and unchecked boxes that represent fields of information
The Checkboxes in column A, each represent their row.
E.g. Checkbox a34 represents row 34(B-UB), checkbox a32 represents row 32(B-UB) etc.
Not every cell in the rows will contain data in them.
> When a row is Checked, I only want the Total Tally to include columns with information contained in that cell.
E.g. Checkbox a34 gets checked. In Row 34(B-UB) (within the table), only cells D34, E34, J34, K34, L34 & Q34 have data in them.
Data = any word, letter, number/s, combination, or checked box. Non Data filled cell = Empty or unchecked box
Therefore the Total Tally Box only has data from Columns D, E, J, K, L & Q
> If more than one checkbox/row is checked, then the Total Tally includes columns that have data in each of the rows checked
E.g. Checkboxes a34, a91 & a128 gets checked.
In Row 34 (B-UB) (within the table), only cells D34, E34, J34, K34, L34 & Q34 have data in them.
In Row 91 (B-UB) (within the table), only cells D91, F91, I91, J91, L91 & M91 have data in them.
In Row 128 (B-UB) (within the table), only cells D128, H128, J128, L128, N128 & Q128 have data in them.
Only Columns D, J & L have data cells from each row checked
Therefore the Total Tally Box only has data from Columns D, J & L
E.g. Checkbox a34 is checked, therefore columns B-UB are totalled as normal
on the condition that their cell in row 34 has data in it (any word or number).
Columns with cell 34 blank/unmarked are not included in Trail Tally Box
Bookmarks