Results 1 to 4 of 4

Dynamic Range Help

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,071

    Dynamic Range Help

    To all Excel experts,

    I have a file here that I've been trying to do the total counts based on 2 criterias, namely number and month. To be more clearer, I have attached a file.

    The goal is simple, yet, I can't achieve it. On Sheet1 where all datas are gathered, I would like to create a cumulative frequencies distribution, but it has to meet the 2 criterias, which is on "Dynamic Frequencies Sheet".

    Thus, taking number 15 for example, it should have given me an answer of 3 on cell B16 & C16 (number 15 appears 3 times on the month of January and February from Sheet1) on Dynamic Frequencies Sheet, 2 on cell D16 and E16 (number 15 appears twice on the month of March and April).

    I believe the attached file explains it clearly. Also, taking this opportunity, thank you in advanced for helping me out.
    Attached Files Attached Files
    Last edited by dluhut; 05-12-2011 at 03:07 PM.

Thread Information

Users Browsing this Thread

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

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