Solve : Help with Excel 2007?

1.	Solve : Help with Excel 2007?
Answer» Is there any way i can find cells of the same value then find the average of the cost. for example, say Item 1 has been sold 20 times at different prices. Can i find all of item 1 then average them. Does this help you? http://www.eggheadcafe.com/software/aspnet/30850642/show-average-value-as-a-horizontal-line-in-a-column-chart.aspx truenorthI not sure what your are trying to do. Getting the average of a row or column is pretty simple, and I'm sure you know how to do that. How about a little more detail.Thanks for that. The way ive tried is to, first name a cell 'item 1' then filter my item LIST, so it just brings up item 1 and average it (next to the 'item 1' cell, then take the filter off. I think this works but i'll have to check it with a calculator before a do the other 9 items. If anyone can see a fault in this, let me know. Thanks again.The AVERAGEIF function may be a simpler solution.reddevilggg Have you read my suggestion? I t sounds as if it is EXACTLY what you are trying to do. truenorth Quote from: truenorth on January 29, 2011, 06:41:45 AM reddevilggg Have you read my suggestion? I t sounds as if it is EXACTLY what you are trying to do. truenorth truenorth, the link you posted is focused on creating a chart. reddevilggg is not trying to create a chart. i have a number of items that have been hired out, so each have different charges for each. Item 1 , for example, has been hired out a number of times for different lengths of time, so has different charges assigned to it. I want to find the average revenue from just item 1. If i filter it, then find the average from the filtered view, it still counts all the other items as well. I can do it manually but i have over 200 ROWS and its hard work PLOWING through it. Is that any clearer? Quote from: oldun on January 28, 2011, 05:49:23 PM The AVERAGEIF function may be a simpler solution. Have you tried this? I believe it could work for you. Here's REFERENCE on using this function: http://spreadsheets.about.com/od/excelfunctions/qt/2007_averageif.htm Thanks, im just looking over it now Yes it worked, thanks alot guys Good stuff. I've had to deal with a similar problem before and this discussion LED me to a solution Thanks all who posted

Answer»
Is there any way i can find cells of the same value then find the average of the cost.

for example, say Item 1 has been sold 20 times at different prices. Can i find all of item 1 then average them. Does this help you?
http://www.eggheadcafe.com/software/aspnet/30850642/show-average-value-as-a-horizontal-line-in-a-column-chart.aspx
truenorthI not sure what your are trying to do. Getting the average of a row or column is pretty simple, and I'm sure you know how to do that. How about a little more detail.Thanks for that.

The way ive tried is to, first name a cell 'item 1' then filter my item LIST, so it just brings up item 1 and average it (next to the 'item 1' cell, then take the filter off. I think this works but i'll have to check it with a calculator before a do the other 9 items.

If anyone can see a fault in this, let me know.

Thanks again.The AVERAGEIF function may be a simpler solution.reddevilggg Have you read my suggestion? I t sounds as if it is EXACTLY what you are trying to do. truenorth Quote from: truenorth on January 29, 2011, 06:41:45 AM

reddevilggg Have you read my suggestion? I t sounds as if it is EXACTLY what you are trying to do. truenorth

truenorth, the link you posted is focused on creating a chart. reddevilggg is not trying to create a chart.
i have a number of items that have been hired out, so each have different charges for each.

Item 1 , for example, has been hired out a number of times for different lengths of time, so has different charges assigned to it.

I want to find the average revenue from just item 1. If i filter it, then find the average from the filtered view, it still counts all the other items as well. I can do it manually but i have over 200 ROWS and its hard work PLOWING through it.

Is that any clearer? Quote from: oldun on January 28, 2011, 05:49:23 PM

The AVERAGEIF function may be a simpler solution.

Have you tried this? I believe it could work for you. Here's REFERENCE on using this function: http://spreadsheets.about.com/od/excelfunctions/qt/2007_averageif.htm
Thanks, im just looking over it now
Yes it worked, thanks alot guys Good stuff.

I've had to deal with a similar problem before and this discussion LED me to a solution

Thanks all who posted

Solve : Help with Excel 2007?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment