If Function Adjustment Request.

[SVTF]

I have a work book that has 2 sheets.

Selection (sheet 1) is used for entry:

• Survivor Selection - (green) you put an x in 8 columns under a Survivor (I have 3 examples set up)

• As each Survivor gets booted out (red) you enter a number to show the order they got booted. I have already booted them all.

• You get a points for every boot: Went out 3rd you get 3 points, went out 10th you get 10 points etc. But .... on Master Points (sheet 2) its only suppose to give you the points if you have selected that Survivor.

Out of the 3 examples I have set up it is only working for the 1st record.
The other 2 exmaples are adding up all 16 entries to equal 136 when they should only equal 90 and 48 respectively.

Master Points (sheet 2)

• is suppose to only calculate the points for the survivor(s) you have picked via the x.

The the if statment is on C6:R6 entry 1 (works), entry 2 c50:r50, entry 3 c74:r74.

It is getting the boot info for all entrys from C3:R3

See the attached I suspect I need to modify the if statment for the 2nd and 3rd entry.

Just not sure how.

[p24leclerc]

You don't saw it because the cells are all black but when the cell in Selection is empty, your formula returns 0 instead of being blank. This makes your If formula (=IF((C73<>"");C$3;"")) to evaluate as TRUE each time and it counts the points. Instead, check if the value is different then 0 like here:

Please Login or Register  to view this content.

It should solve your issue.

[SVTF]

You don't saw it because the cells are all black but when the cell in Selection is empty, your formula returns 0 instead of being blank. This makes your If formula (=IF((C73<>"");C$3;"")) to evaluate as TRUE each time and it counts the points. Instead, check if the value is different then 0 like here:

Please Login or Register  to view this content.

It should solve your issue.

Thanks ... seems to be working.

I had to swap out the ; to , though.

[SVTF]

The if statment has gone bad ... I messed something up.

Have a look at the attachement.

Sheet 1 (selection) is only to enter info.
Points are calculated on Sheet 2 (master points)

Sheet 2 should only be adding up the points with the x in the column's.
I have messed something up ...

Please Login or Register  to view this content.

My row C49:T49 no longer equals the zero's?

C49=Selection!C5 ... etc

Easy fix I am sure.

Thanks in advance.

[p24leclerc]

It was simple, indeed but not obvious to see.
In your sheet Selection, you inserted the string " " which has a space in it instead of being a NULL string. That changes all the things. Go to your sheet Selection and delete the content of every cells that donot have an X in it.
Regards
Pierre

[SVTF]

It was simple, indeed but not obvious to see.
In your sheet Selection, you inserted the string " " which has a space in it instead of being a NULL string. That changes all the things. Go to your sheet Selection and delete the content of every cells that donot have an X in it.
Regards
Pierre

Thanks again - That worked.