+ Reply to Thread
Results 1 to 10 of 10

I need to show the number of occurances of each unit in a given month

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Cape Girardeau, MO
    MS-Off Ver
    Excel 2007
    Posts
    13

    I need to show the number of occurances of each unit in a given month

    Hello Forum!

    I am in need of a formula. What I need to do is on the tabs of charts by unit and incident type, you will see that there is a total for all year and then there is the month headers. I tried to use the countifs formula but I get lost when searching for the unit number or the incident type by month. I think that I am close to figuring it out but I need a teacher to have the lesson that I need to learn.

    In the tab of incident ype, there is a caluation for the main chart, but when I try to use the countif formula to specify the incident type per month, I get lost.

    The same for the unit number.

    The information contained within the workbook is public record.

    I have attached a copy of the workbook.

    Thank you,

    Luther
    Attached Files Attached Files
    Last edited by lex.luthor; 06-23-2022 at 11:35 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,402

    Re: formula help needed

    Administrative Note:



    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-09-2013
    Location
    Cape Girardeau, MO
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: formula help needed

    Hello Richard. I think that I have edited as per request. Thank you

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,497

    Re: countif formula help

    No, Lex - this will NOT do.

    Tell us what you are trying to do, NOT how you think it should be done. Don't mention function names - just tell us what you want to achieve.

    Try again, please. This new title is not good enough.

    Are you still using Excel 2007??? If not, you also need to update your forum profile.
    Last edited by AliGW; 06-23-2022 at 09:57 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  5. #5
    Registered User
    Join Date
    04-09-2013
    Location
    Cape Girardeau, MO
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: countif formula help

    Hello Ali,

    Sorry, this has done my head in. I am unsure of how to word it since things have changed when I was absent.

    In the tab marked charts by unit, in the other columns, I want or need to show the number of occurances of each unit in that month. I am unsure of on how that formula or what formula to use. I normally would not bother anyone on it because I usually research it on the web, but this one has be bashing my head.

    As for the version, I have been using librecalc on windows 10 in which Apple converts it to excel 2007+ on my Ipad mini gen 1. I can change it in the profile if it is there.

    Again, sorry for the bother and thank you.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,497

    Re: countif formula help

    OK - your title should be: "I need to show the number of occurances of each unit in a given month".

    Change it NOW, please.

  7. #7
    Registered User
    Join Date
    04-09-2013
    Location
    Cape Girardeau, MO
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: countif formula help

    Ali, tapadh leat!

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,497

    Re: I need to show the number of occurances of each unit in a given month

    Google tells me: Se do bheatha.

    I hope, if nothing else, you now understand what we expect from you in ALL your thread titles.

  9. #9
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,817

    Re: I need to show the number of occurances of each unit in a given month

    Try

    In D2

    =COUNTIFS(INDIRECT("'"&D$1&"'!$F:$F"),"="&$A2)

    copy across and down
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,000

    Re: I need to show the number of occurances of each unit in a given month

    With a pivot table.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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] Improved Formula / i've run out room to extend the current formula / (avdanced code needed
    By pmw19800 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2018, 06:19 AM
  2. date formula help needed with blank cell and monthly assumtions formula needed
    By Michael.Howarth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2018, 07:47 AM
  3. Replies: 3
    Last Post: 04-06-2016, 12:19 PM
  4. Replies: 1
    Last Post: 01-11-2016, 02:31 PM
  5. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  6. [SOLVED] index formula needed--how to get a formula to skip columns
    By rsmidtisu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-02-2012, 11:22 AM
  7. Replies: 3
    Last Post: 09-07-2012, 12:07 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