Results 1 to 15 of 15

[Sovled] Question Count fomula?

Threaded View

  1. #1
    Registered User
    Join Date
    12-12-2012
    Location
    Ohio, US
    MS-Off Ver
    Excel 2010
    Posts
    9

    [Sovled] Question Count fomula?

    Hello,

    I have been using this formula

    =COUNTIF(Master!I:I,'Source Lists'!A1) It is counting trends for the year, in a summary tab. (this works)

    (Master is a tab with all the daily information for incidents, The Source list is a seprate tab where I put my pull down menu information, and this is going in a thrid tab called trends. )

    The "master" tab has a date column 01/11/12 format I would like to set up the summry tab by month is there a way to add that to this formula?

    Currently the trend tab/sheet looks like this

    ......................Total
    MUI - Verbal ......5
    MUI - Physical.....0
    MUI - ***...........0


    I want to track trends monthly and quarterly

    ...................... Jan.... Feb ...March .... Total
    MUI - Verbal........2.....3........0
    MUI - Physical .....0.....0........0
    MUI - *** ...........0.....0.......0

    I hope I have given enough inoformation, Thank you, Excel 2010
    Last edited by Gleowine; 12-18-2012 at 04:04 PM.

Thread Information

Users Browsing this Thread

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

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