Excel Trend Calculation
 

This will be a very easy problem for someone other than myself. I have
a table that includes, for example, widgets of different colors and
values. By way of example, here is my problem:

A B C
1 Blue 8
2 Red 6
3 Blue 7
4 Green 8
5 Red 7
6 Blue 6 6

Now, column A are the widget colors, B are their values and C would be
the trend of the values for the colors on the corresponding rows. So,
my formula in C6 would need to return the Trend in value for the Blue
widgets only. Please, someone, HELP!

Excel Trend Calculation
 

Try stating your question more clearly.

Jerry

Smitty wrote:

This will be a very easy problem for someone other than myself. I have
a table that includes, for example, widgets of different colors and
values. By way of example, here is my problem:

A B C
1 Blue 8
2 Red 6
3 Blue 7
4 Green 8
5 Red 7
6 Blue 6 6

Now, column A are the widget colors, B are their values and C would be
the trend of the values for the colors on the corresponding rows. So,
my formula in C6 would need to return the Trend in value for the Blue
widgets only. Please, someone, HELP!