Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAJOR Worksheet Dilemma
I have a spreadsheet that will end up containing 6 worksheets. In each
worksheet there are sets of questions and hold answers of either a 1, 2, 3, or NA. I know that I can use a CountIF function to count all the 1's, 2's and such, but i have to have 4 seperate columns for each. Is there a way to use an IF function with a Count function to do this easier...such as IF(G1:G215=1,Count.....) at this point I get lost!! What I am trying to do is create a PivotChart that will show the differences between the 1, 2, 3, and NA answers for each of these questions for each worksheet. ANY HELP WOULD BE GREATLY APPRECIATED -- Sandi Gardner |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAJOR Worksheet Dilemma
I think you just want
=COUNTIF(G1:G215,1) then 2,3 etc. NA can be =COUNTIF(F1:G215,"NA") if just that text, -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sandi" wrote in message ... I have a spreadsheet that will end up containing 6 worksheets. In each worksheet there are sets of questions and hold answers of either a 1, 2, 3, or NA. I know that I can use a CountIF function to count all the 1's, 2's and such, but i have to have 4 seperate columns for each. Is there a way to use an IF function with a Count function to do this easier...such as IF(G1:G215=1,Count.....) at this point I get lost!! What I am trying to do is create a PivotChart that will show the differences between the 1, 2, 3, and NA answers for each of these questions for each worksheet. ANY HELP WOULD BE GREATLY APPRECIATED -- Sandi Gardner |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAJOR Worksheet Dilemma
I did that already, but that gives me having 36 different formuals each in
seperate columns so that my PivotTable would recognize them by the time I am finished I was trying to avoid that. I was hoping that there would be something else easier taht I could do. -- Sandi Gardner "Bob Phillips" wrote: I think you just want =COUNTIF(G1:G215,1) then 2,3 etc. NA can be =COUNTIF(F1:G215,"NA") if just that text, -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sandi" wrote in message ... I have a spreadsheet that will end up containing 6 worksheets. In each worksheet there are sets of questions and hold answers of either a 1, 2, 3, or NA. I know that I can use a CountIF function to count all the 1's, 2's and such, but i have to have 4 seperate columns for each. Is there a way to use an IF function with a Count function to do this easier...such as IF(G1:G215=1,Count.....) at this point I get lost!! What I am trying to do is create a PivotChart that will show the differences between the 1, 2, 3, and NA answers for each of these questions for each worksheet. ANY HELP WOULD BE GREATLY APPRECIATED -- Sandi Gardner |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAJOR Worksheet Dilemma
You can copy them across if the effort is your concern.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sandi" wrote in message ... I did that already, but that gives me having 36 different formuals each in seperate columns so that my PivotTable would recognize them by the time I am finished I was trying to avoid that. I was hoping that there would be something else easier taht I could do. -- Sandi Gardner "Bob Phillips" wrote: I think you just want =COUNTIF(G1:G215,1) then 2,3 etc. NA can be =COUNTIF(F1:G215,"NA") if just that text, -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sandi" wrote in message ... I have a spreadsheet that will end up containing 6 worksheets. In each worksheet there are sets of questions and hold answers of either a 1, 2, 3, or NA. I know that I can use a CountIF function to count all the 1's, 2's and such, but i have to have 4 seperate columns for each. Is there a way to use an IF function with a Count function to do this easier...such as IF(G1:G215=1,Count.....) at this point I get lost!! What I am trying to do is create a PivotChart that will show the differences between the 1, 2, 3, and NA answers for each of these questions for each worksheet. ANY HELP WOULD BE GREATLY APPRECIATED -- Sandi Gardner |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAJOR Worksheet Dilemma
It's not the effort that I am concerned with, I just didn't want to have a
spreadsheet than spanned across to column CJ. That's how far over it went when I did it the first time. I was trying to minimize that's all. I guess since it appears this is the only way, that is what I will stick with. Thanks so much. -- Sandi Gardner "Bob Phillips" wrote: You can copy them across if the effort is your concern. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sandi" wrote in message ... I did that already, but that gives me having 36 different formuals each in seperate columns so that my PivotTable would recognize them by the time I am finished I was trying to avoid that. I was hoping that there would be something else easier taht I could do. -- Sandi Gardner "Bob Phillips" wrote: I think you just want =COUNTIF(G1:G215,1) then 2,3 etc. NA can be =COUNTIF(F1:G215,"NA") if just that text, -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sandi" wrote in message ... I have a spreadsheet that will end up containing 6 worksheets. In each worksheet there are sets of questions and hold answers of either a 1, 2, 3, or NA. I know that I can use a CountIF function to count all the 1's, 2's and such, but i have to have 4 seperate columns for each. Is there a way to use an IF function with a Count function to do this easier...such as IF(G1:G215=1,Count.....) at this point I get lost!! What I am trying to do is create a PivotChart that will show the differences between the 1, 2, 3, and NA answers for each of these questions for each worksheet. ANY HELP WOULD BE GREATLY APPRECIATED -- Sandi Gardner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multple criteria dilemma | Excel Worksheet Functions | |||
Nth power dilemma | Excel Discussion (Misc queries) | |||
Rolling up to the correct Month Dilemma | Excel Discussion (Misc queries) | |||
The Prisoner's Dilemma | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions |