Formula Problem

[fredmr]

I have one set of equations that work.
COL E gets "points" entered daily-
COL J keeps Cumulative totals of COL E for the year.
The equation I use for for COL J is: =IF(E4>10,(J4+E4/10),J4)

I have another equation I cannot figure out.
COL G gets a number entered from a "Chart" when the worksheet is "Recalculated" each Day (Like: 1.50; 2.75; 5.25; 0.50; etc; or sometimes No Entry (BLANK).
COL M is the Column I want to keep a Cumulative total of COL G for the year.
I have tried a bunch of equations and none of them work. (I get #VALUE, FALSE, (a BLANK), and other errors no mater what I try.)

Note: the Chart that posts to COL G is fromV6-AA6 to V27-AA27 on the same worksheet with the equation: =IF(ISNA(MATCH(F4,$V$7:$V$26,0)),"",INDEX($W$7:$AA$26,MATCH(F4,$V$7:$V$26,0),MATCH($E$27,$W$6:$AA$6,0)))

I sure hope that someone has some suggestions as I'm about to go nuts.
As you can see, I'm new at Excel.
I'm working with Win XP and Excel 2003.

If someone will at least tell that I can’t do what I’m trying to do please do so--or--give me a hint on how to precede.



Thanks, Fred

 

[JakeTheSnake3.0]

Can you explain what it is you're trying to do exactly? Not in terms of equations but in terms of a broader sense. I don't know WHY your formula is the way it is so I can't really help you. Can you break things down to the simplest components?

 

[fredmr]

Each day people go out in groups of 4, or 8, 12, 16, or 20.

Each day each person records his results next to his name.(COL E)

The numbers are Ranked Largest to Smallest (COL F)

I have a Table that returns a Number to a COL (G) next to each persons name according to their Ranking.

I want to keep a Cumlative Total of each persons "Numbers" over the Year (COL M).

Note: At Years end awards will be made according to each persons Ranking (COL M).

Does this do it for you?

Fred

 

[JakeTheSnake3.0]

Something like this is best solved by layout. You'd use excel's SUMIF function to set the SUM based on the value of the name. So for example if you had a couple of columns (A & B), where A was the name of the person and B was their score...

Let's populate some data...from rows 2 - 9. On a random cell, let's say "G1", let's put the formula:

=SUMIF(A2:A9,"Bob",B2:B9)

There are also plenty of options with using named ranges and such...

 

[fredmr]

Thank you Jake-I'll see what I can do using this approach. I'll let you no how I mane out.

Thanks