What is the easiest method to organize daily data/percentages to a monthly percentage?

I don't get it - sorry! Please explain the attachment - what exactly are you trying to do? Could you reattach the example sheet and perhaps indicate in colour where you want things to appear and show where they are coming from? There are three tabs in the workbook and absolutely no notes from you at all!

LoL this is a continuation of a thread he started yesterday where he just kept doubling down on the ambiguity.

Thread WITH my solved samples below.
http://www.excelforum.com/showthread...57#post4433357

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. You may continue in your other thread.

Do not continue in this thread.

Originally Posted by taylorsm

Sorry, not real sure how to explain more. A = Dates, B:D are categories, E=total of categories. I want to know that B2 is % of E2. and So on. Then to have that on a monthly scale. The worksheet Example gives you N:O which does that, BUT that just shows it for that day, it doesn't tell you what the % was for the month of June.
Typically a pivot table would work, but to do a pivot table, my original data has to look like sheet 1, which if you don't know excel, is a lot of data to see and is not simple friendly.
So basically, "Example" is what I want, but in a clean format that will show monthly average totals as well. Does that help?

Shane,

What we are looking for in a sample is not your words to explain it, but a before then a SOLVED after. So you can show us with hand typed numbers if you have to, or ONE formula for ONE particular example and ask how to make a formula work for ALL examples.

Take a look at what I posted in your thread from yesterday and see if that works.

Originally Posted by taylorsm

Typically a pivot table would work, but to do a pivot table, my original data has to look like sheet 1, which if you don't know excel, is a lot of data to see and is not simple friendly.

LOL! "...If you don"t know excel...", he says to the person offering to help... That made my morning.

I would make up a table like this...

	J	K	L	M	N	O	P	Q
1		No Show	CDC	General	Total	% no show	% cdc	% general
2	6/1/2016	128	131	128	387.00	33.07%	33.85%	33.07%
3	7/1/2016	116	106	104	326.00	35.58%	32.52%	31.90%
4	8/1/2016	40	46	29	115.00	34.78%	40.00%	25.22%
5	9/1/2016	0	0	0	0.00
6	10/1/2016	0	0	0	0.00
7	11/1/2016	0	0	0	0.00
8	12/1/2016	0	0	0	0.00
9	1/1/2017	0	0	0	0.00
10	2/1/2017	0	0	0	0.00
11	3/1/2017	0	0	0	0.00

K2=SUMIFS(B:B,$A:$A,">="&$J2,$A:$A,"<"&EDATE($J2,1))
copied across 2 and down as needed

N2=SUM(K2:M2)
O2=IFERROR(K2/$N2," ")
copied across
then all copied down as needed

ooops need to refresh more often, did not see the previous comments

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.