Hello,
What I am looking to do is formulate a sheet so that at the end of a month, it will take the data within each month separately, use COUNTIF to let me know what happened in each month for each piece of data. It's a study of random that has been plaguing me for some time now and the 'ole brain won't cease about. I have a test sheet included.
Column A is the Date with B,C and D the data. E thru R is insignificant to what I'm looking at, but there. S will be the month summed up to it's simplest form and part of where I'm looking at. T and U is insignificant for now. W thru AF is where I'm counting up the data. BO and beyond is just something I was trying to use as a way to simplify what I'm trying to do. Can be used if needed.
Starting in W28 will be the end of the 4th month of that year. That's where I want to collect all the data from the 4th month and show it for each piece. I could use an extensive IF(AND(formula that would make a HUGE and slow sheet but am looking for a simpler way. If at all possible. My PC can handle fairly large amounts of formulas, but some of the people I will be sharing copies with may not, and I really don't have the time to make a fresh copy for every one that might want it.
Anyone have any ideas as to how to go about this without spending to much of your time on it?
Thank you all again, (been out of the game for a spell and pretty rusty here.
Bookmarks