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.
Bookmarks