# Totalling Columns, filtering the data by Checkboxes

1. ## Totalling Columns, filtering the data by Checkboxes

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

3. ## Re: Totalling Columns, filtering the data by Checkboxes

Its a google sheet I, I've been trying to share the link but the forum won't let me yet.
I'll have to find out how first. The document is attached, but I'm hoping to be able to use google sheets to code the formulas.

Hope this helps!

There are currently 1 users browsing this thread. (0 members and 1 guests)