Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula
I'm trying to create an auto-count feature for a points system. 1st = 6
points, 2nd = 4 points, 3rd = 3, 4th=2, 5th=1. The points will all be in a single row that could span 40 columns. Some cell may have points, some may not. Any idea of a formula that I could put in the total field that would calculate every result? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula
On Aug 6, 2:42*pm, Dean Schmaus
wrote: I'm trying to create an auto-count feature for a points system. *1st = 6 points, 2nd = 4 points, 3rd = 3, 4th=2, 5th=1. *The points will all be in a single row that could span 40 columns. *Some cell may have points, some may not. *Any idea of a formula that I could put in the total field that would calculate every result? SUM function works, or do you want Coutn as stated. CountA? .Column.Count? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula
I think I'll have to put an IF statement in there somewhere. For example, if
the person gets 1st place, they get 6 points, 2nd place is 4 points, etc. This strategy is the same for every cell in the row. "Simon" wrote: On Aug 6, 2:42 pm, Dean Schmaus wrote: I'm trying to create an auto-count feature for a points system. 1st = 6 points, 2nd = 4 points, 3rd = 3, 4th=2, 5th=1. The points will all be in a single row that could span 40 columns. Some cell may have points, some may not. Any idea of a formula that I could put in the total field that would calculate every result? SUM function works, or do you want Coutn as stated. CountA? .Column.Count? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula
On Aug 6, 3:04*pm, Dean Schmaus
wrote: I think I'll have to put an IF statement in there somewhere. *For example, if the person gets 1st place, they get 6 points, 2nd place is 4 points, etc. * This strategy is the same for every cell in the row. "Simon" wrote: On Aug 6, 2:42 pm, Dean Schmaus wrote: I'm trying to create an auto-count feature for a points system. *1st = 6 points, 2nd = 4 points, 3rd = 3, 4th=2, 5th=1. *The points will all be in a single row that could span 40 columns. *Some cell may have points, some may not. *Any idea of a formula that I could put in the total field that would calculate every result? SUM function works, or do you want Coutn as stated. CountA? *.Column.Count?- Hide quoted text - - Show quoted text - Thats correct, depends if you want to show that. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula
I guess I'm looking for some assistance writing the formula. I know I'll
have to say that IF C5="1st", then add 6,OR IF C5=2nd, then add 4, etc. I just don't know how to put it all together accurately. "Simon" wrote: On Aug 6, 3:04 pm, Dean Schmaus wrote: I think I'll have to put an IF statement in there somewhere. For example, if the person gets 1st place, they get 6 points, 2nd place is 4 points, etc. This strategy is the same for every cell in the row. "Simon" wrote: On Aug 6, 2:42 pm, Dean Schmaus wrote: I'm trying to create an auto-count feature for a points system. 1st = 6 points, 2nd = 4 points, 3rd = 3, 4th=2, 5th=1. The points will all be in a single row that could span 40 columns. Some cell may have points, some may not. Any idea of a formula that I could put in the total field that would calculate every result? SUM function works, or do you want Coutn as stated. CountA? .Column.Count?- Hide quoted text - - Show quoted text - Thats correct, depends if you want to show that. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula
On Aug 6, 4:16*pm, Dean Schmaus
wrote: I guess I'm looking for some assistance writing the formula. *I know I'll have to say that IF C5="1st", then add 6,OR IF C5=2nd, then add 4, etc. *I just don't know how to put it all together accurately. "Simon" wrote: On Aug 6, 3:04 pm, Dean Schmaus wrote: I think I'll have to put an IF statement in there somewhere. *For example, if the person gets 1st place, they get 6 points, 2nd place is 4 points, etc. * This strategy is the same for every cell in the row. "Simon" wrote: On Aug 6, 2:42 pm, Dean Schmaus wrote: I'm trying to create an auto-count feature for a points system. *1st = 6 points, 2nd = 4 points, 3rd = 3, 4th=2, 5th=1. *The points will all be in a single row that could span 40 columns. *Some cell may have points, some may not. *Any idea of a formula that I could put in the total field that would calculate every result? SUM function works, or do you want Coutn as stated. CountA? *.Column.Count?- Hide quoted text - - Show quoted text - Thats correct, depends if you want to show that.- Hide quoted text - - Show quoted text - Oh I see what you mean, yes that would be fin, possibly conditional format or Vlookup. Can you only use one like? =IF(A1=1, 6, "") This means, if A1 = 6 (6 points for coming 1st, a 6 is displayed otherwise nothing, is this what you are after?). You're on the wrong board though mate , this is using code with Visual Basic. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |