averaging different cells from specified categories

[bob hanle]

I want to average cells in different columns which meet a minimum criteria, i.e. > 2.0, from specified categories list in the first column. Example: I want to select a category listed in column A and average the numbers listed in columns C and F for that category which meet a minimum threshold. Thanks

 

[bob hanle]

Would you elaborate a bit in full extenso? Perhaps using a small sample...

I have the following columns of data: I want to calculate a weighted average for the data in "WR% Profit" columns based on the number of trades in the "total trades" columns. The copy and paste data below didn't turn out quite lined up but I hope you can get the idea of what I want to do. Thanks

Net	Total	WR%	Profit	Net	Total	WR%	Profit	Net	Total	WR%	Profit
Profit	Trades	Profit	Factor	Profit	Trades	Profit	Factor	Profit	Trades	Profit	Factor
2,170.00	308	62.66	0.95	5,150.00	65	46.15	0.50	3,670.00	42	76.19	2.13
175.00	295	64.41	1.00	590.00	73	57.53	0.97	2,045.00	27	51.85	0.61
105.00	319	63.64	1.00	8,885.00	68	70.59	1.92	4,335.00	43	48.84	0.52
5,395.00	309	63.11	0.89	4,405.00	76	53.95	0.78	3,150.00	32	78.13

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup>

 

[bob hanle]

I have the following columns of data: I want to calculate a weighted average for the data in "WR% Profit" columns based on the number of trades in the "total trades" columns. The copy and paste data below didn't turn out quite lined up but I hope you can get the idea of what I want to do. Thanks

Net	Total	WR%	Profit	Net	Total	WR%	Profit	Net	Total	WR%	Profit
Profit	Trades	Profit	Factor	Profit	Trades	Profit	Factor	Profit	Trades	Profit	Factor
2,170.00	308	62.66	0.95	5,150.00	65	46.15	0.50	3,670.00	42	76.19	2.13
175.00	295	64.41	1.00	590.00	73	57.53	0.97	2,045.00	27	51.85	0.61
105.00	319	63.64	1.00	8,885.00	68	70.59	1.92	4,335.00	43	48.84	0.52
5,395.00	309	63.11	0.89	4,405.00	76	53.95	0.78	3,150.00	32	78.13

<tbody>
</tbody>

 

[Aladin Akyurek]

I have the following columns of data: I want to calculate a weighted average for the data in "WR% Profit" columns based on the number of trades in the "total trades" columns. The copy and paste data below didn't turn out quite lined up but I hope you can get the idea of what I want to do. Thanks

Net	Total	WR%	Profit	Net	Total	WR%	Profit	Net	Total	WR%	Profit
Profit	Trades	Profit	Factor	Profit	Trades	Profit	Factor	Profit	Trades	Profit	Factor
2,170.00	308	62.66	0.95	5,150.00	65	46.15	0.50	3,670.00	42	76.19	2.13
175.00	295	64.41	1.00	590.00	73	57.53	0.97	2,045.00	27	51.85	0.61
105.00	319	63.64	1.00	8,885.00	68	70.59	1.92	4,335.00	43	48.84	0.52
5,395.00	309	63.11	0.89	4,405.00	76	53.95	0.78	3,150.00	32	78.13

<tbody>
</tbody>

How would 62.66 be calculated manually?

 

[bob hanle]

All the numbers in the spread sheet are absolute values, the values are not based on formulas in the cell. Thanx

 

[Aladin Akyurek]

All the numbers in the spread sheet are absolute values, the values are not based on formulas in the cell. Thanx

Can you give a manual example of such an average from the exhibit?

Ordinarily, we would have:

=SUMPRODUCT(values,frequencies)/SUM(frequencies)

 

[bob hanle]

Can you give a manual example of such an average from the exhibit?

Ordinarily, we would have:

=SUMPRODUCT(values,frequencies)/SUM(frequencies)

Here is a simple example:

Total
Trades	WR%
295	64.41
73	57.53
63.04522

<colgroup><col width="64" style="width: 48pt;" span="2">
<tbody>


</tbody>

So based on the "total trades" I determined that the weighted average of the WR% is 63.05. Does htis help?

 

[Aladin Akyurek]

Here is a simple example:

Total
Trades	WR%
295	64.41
73	57.53
63.04522

<tbody>
</tbody>

So based on the "total trades" I determined that the weighted average of the WR% is 63.05. Does htis help?

Right...

=SUMPRODUCT(A2:A3,B2:B3)/SUM(A2:A3)

where A2:A3 consists of trade counts.

 

[bob hanle]

An added observation: And I need calculate the number from across different columns of "total trades" and "WR%" not necessarily from the same column as in the example just sent to you.

 

[bob hanle]

See the post I just sent

 

[bob hanle]

So the question is: Can I write a "sumproduct" formula that utilizes the data in Row 2 for "total trades" data in the separate columns of B, F, & J for a weighted average in the same row "for WR%" columns C, G, & K?