Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give each NO in a drop down a different value
I have a worksheet in which I want to be able to give the NO's in the drop
down a different value so that the total value when added up will tell me the number of guided learning hours required for the individual. I hope this makes sense.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give each NO in a drop down a different value
Maybe something like this
Assuming data in A2:A10 (including "No"'s) where each "No" = to deduct 5 marks, say In B2: =SUM(A2:A10)-(COUNTIF(A2:A10,"No")*5) -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Shevy" wrote: I have a worksheet in which I want to be able to give the NO's in the drop down a different value so that the total value when added up will tell me the number of guided learning hours required for the individual. I hope this makes sense.. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give each NO in a drop down a different value
Max
sorry as you might of guessed excel aint my strongest... What i need to tally up is if the NO = 2 in A2 4 in A3 6 in A3 10 in A4 Which would give me a total of 22 and all the YES would = 0 "Max" wrote: Maybe something like this Assuming data in A2:A10 (including "No"'s) where each "No" = to deduct 5 marks, say In B2: =SUM(A2:A10)-(COUNTIF(A2:A10,"No")*5) -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Shevy" wrote: I have a worksheet in which I want to be able to give the NO's in the drop down a different value so that the total value when added up will tell me the number of guided learning hours required for the individual. I hope this makes sense.. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give each NO in a drop down a different value
Still vague to me, I'm afraid, but here's another guess
In C2: =SUMIF(A2:A10,"No",B2:B10) where A2:A10 would house the "No", "Yes" indications with B2:B10 containing the corresponding numbers to be summed Did the above hit the barndoor? wave it, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Shevy" wrote: What i need to tally up is if the NO = 2 in A2 4 in A3 6 in A3 10 in A4 Which would give me a total of 22 and all the YES would = 0 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give each NO in a drop down a different value
Ok lets have one more go at this.... IF
A2 no (HAS VALUE OF 2) A3 no (HAS VALUE OF 6) A4 no (HAS VALUE OF 2) A5 yes (HAS VALUE OF 0) A6 no (HAS VALUE OF 5) A7 no (HAS VALUE OF 2) A8 yes (HAS VALUE OF 0) So what I need to know is if you was answering these questions above how would I be able to value the NO's with a different value?? So the total at the bottom would add up all the values ofcourse ignoring the YES's as they have zero value... at present I have =COUNTIF(I14:I33,"NO") but that is counting NO as 1 "Max" wrote: Still vague to me, I'm afraid, but here's another guess In C2: =SUMIF(A2:A10,"No",B2:B10) where A2:A10 would house the "No", "Yes" indications with B2:B10 containing the corresponding numbers to be summed Did the above hit the barndoor? wave it, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Shevy" wrote: What i need to tally up is if the NO = 2 in A2 4 in A3 6 in A3 10 in A4 Which would give me a total of 22 and all the YES would = 0 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give each NO in a drop down a different value
Assuming your "hidden" weights for "No" in A2:A8
a 2;6;2;5;5;2;5 then this expression: =SUMPRODUCT(--(A2:A8="No"),{2;6;2;5;5;2;5}) will return it aloha? yes it below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Shevy" wrote: Ok lets have one more go at this.... IF A2 no (HAS VALUE OF 2) A3 no (HAS VALUE OF 6) A4 no (HAS VALUE OF 2) A5 yes (HAS VALUE OF 0) A6 no (HAS VALUE OF 5) A7 no (HAS VALUE OF 2) A8 yes (HAS VALUE OF 0) So what I need to know is if you was answering these questions above how would I be able to value the NO's with a different value?? So the total at the bottom would add up all the values ofcourse ignoring the YES's as they have zero value... at present I have =COUNTIF(I14:I33,"NO") but that is counting NO as 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I give up | Excel Discussion (Misc queries) | |||
Need help! How to give a drop down cell a math value? | Excel Discussion (Misc queries) | |||
Help!! How do you give a drop down a Math Value | Excel Discussion (Misc queries) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
How do I give a name to my group? | Excel Worksheet Functions |