+ Reply to Thread
Results 1 to 3 of 3

Totalling Columns, filtering the data by Checkboxes

  1. #1
    Registered User
    Join Date
    08-29-2019
    Location
    Brisbane, Australia
    MS-Off Ver
    Google Drive Excel
    Posts
    2

    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

  2. #2
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    436

    Re: Totalling Columns, filtering the data by Checkboxes

    Please attach a sample workbook instead of pictures.

  3. #3
    Registered User
    Join Date
    08-29-2019
    Location
    Brisbane, Australia
    MS-Off Ver
    Google Drive Excel
    Posts
    2

    Re: Totalling Columns, filtering the data by Checkboxes

    Thank you for replying!
    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filtering Data with multiple checkboxes
    By Dena in forum Excel General
    Replies: 2
    Last Post: 09-13-2017, 01:41 PM
  2. [SOLVED] formula for totalling columns based on data in rows in another column
    By CraigFOD in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-10-2016, 08:51 AM
  3. [SOLVED] Totalling after filtering
    By djcfisher in forum Excel General
    Replies: 4
    Last Post: 10-16-2012, 05:57 AM
  4. Reformatting columns, creating files, and totalling organized data
    By madfrog in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-13-2010, 06:36 AM
  5. Filtering, Sorting and Then Sub-Totalling
    By wilderfan in forum Excel General
    Replies: 7
    Last Post: 08-12-2010, 02:39 AM
  6. Problems filtering data containing checkboxes???
    By nameyers in forum Excel General
    Replies: 1
    Last Post: 10-18-2007, 02:48 PM
  7. Totalling columns after using Autofilter on data
    By tomholden in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2007, 09:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1