Results 1 to 10 of 10

Totaling columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-13-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    464

    Totaling columns

    Hello,
    I am making a simple spreadsheet to track external queries. It is set up that when the Submit button is selected on the UserForm, the entries in the boxes from the form will go onto Sheet 1 on the next available row. For some of these columns, I would like to generate totals for all of the entries. For example, there are columns 28/29, 27, Local, NCIC that are generated by checkboxes. I want to count all of the TRUE responses for each and place the result onto a REPORT sheet. I imagine this just involves a countifs formula on the REPORTS sheet.

    The tricky part is this...
    I would like to generate daily totals for each shift, and each day, and to date for the year on the REPORTS sheet.

    Can anyone help with these various formulas? Thank you!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 08-21-2013, 12:55 PM
  2. Totaling multiple columns
    By maacmaac in forum Excel General
    Replies: 2
    Last Post: 09-16-2007, 10:17 PM
  3. Totaling Columns
    By GogsJames in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2006, 02:07 AM
  4. [SOLVED] Help with totaling a columns in VBA
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2005, 02:05 PM
  5. [SOLVED] Totaling Columns
    By DNA in forum Excel General
    Replies: 1
    Last Post: 05-05-2005, 09:06 AM

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