Trying to find percentage of winners and losers on certain days

[alexm3430]

Below is the data and formula that was presented to me very helpful but I want to go one more step and that is what if I want to see this data for certain days only like Monday?
Excel 2010

	A	B	C	D	E	F	G
Positive
negative
Day	Year	Month	Dat 2	1	2	3
Sat	Jan
Sun	Jan
Mon	Jan
Tue	Jan
Wed	Jan
Thur	Jan

<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]71.0%[/TD]
[TD="align: right"]67.7%[/TD]
[TD="align: right"]71.0%[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]29.0%[/TD]
[TD="align: right"]32.3%[/TD]
[TD="align: right"]29.0%[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]2011[/TD]

[TD="align: right"]1/1/2011[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]1.9[/TD]
[TD="align: right"]2.67[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]2011[/TD]

[TD="align: right"]1/2/2011[/TD]
[TD="align: right"]-1.9[/TD]
[TD="align: right"]-1.53[/TD]
[TD="align: right"]-1.19[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]2011[/TD]

[TD="align: right"]1/3/2011[/TD]
[TD="align: right"]4.15[/TD]
[TD="align: right"]2.81[/TD]
[TD="align: right"]3.33[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]2011[/TD]

[TD="align: right"]1/4/2011[/TD]
[TD="align: right"]2.16[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.53[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]2011[/TD]

[TD="align: right"]1/5/2011[/TD]
[TD="align: right"]0.97[/TD]
[TD="align: right"]0.95[/TD]
[TD="align: right"]1.87[/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]2011[/TD]

[TD="align: right"]1/6/2011[/TD]
[TD="align: right"]-7.26[/TD]
[TD="align: right"]-5.97[/TD]
[TD="align: right"]-4.46[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E6[/TH]
[TD]=1-E7[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E7[/TH]
[TD]=COUNTIF(E10:E40,"<"&0)/COUNT(E10:E40)

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[BarryL]

create a cell where you will put in the Day as is in column A like you have above. Then use sumifs

e.g.

=SUMIFS(E10:E40,A10:A40,L2)/Count(E10:E40)

where L2 is where I put in "mon" or "Tue" or "Wed" etc.

 

[steve the fish]

Are you meaning you want to find out what percentage of mondays are negative?

=COUNTIFS(A10:A40,"Mon",E10:E40,"<0")/COUNTIF(A10:A40,"Mon")

where "Mon" can be a cell reference if required.

 

[ukmikeb]

This thread is a continuation of previous thread here :-http://www.mrexcel.com/forum/excel-questions/880461-trying-find-percentage-winners-losers.html#post4266536

You should allow at least an hour before "bumping" the original thread and not create a new related thread after 7 minutes!

 

[alexm3430]

it was not 7 minutes it was from yesterday

 

[alexm3430]

yes out of the data i want it to return the percentage of positive and negative on selected dates for example out of the last 60 days how many time was Monday positive and negative.

 

[ukmikeb]

it was not 7 minutes it was from yesterday

I was referring to Post #3 in that thread timestamp Today, 12:58pm.

This thread Post #1 was started with a timestamp Today, 01:05pm.

I rest my case.

 

[alexm3430]

If you need this then you are right