Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting in Excel
I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I
have the sum to count each individually. I now need to be able, in column F, to count the Y and N, split out by T8, T9 and T10 (column C). I've tried counta and countif, putting in different parameters but it doesn't work. I also in column H need to count the Y's again split out by T8, T9 and T10 and in column I (where I have dates) need to count them by T8, T9 and T10. Help please Sheila |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting in Excel
Not sure what you mean by split out but maybe something like this:
=SUMPRODUCT((C1:C100="T9")*(F1:F100="Y")) "Sheila Innes" wrote: I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I have the sum to count each individually. I now need to be able, in column F, to count the Y and N, split out by T8, T9 and T10 (column C). I've tried counta and countif, putting in different parameters but it doesn't work. I also in column H need to count the Y's again split out by T8, T9 and T10 and in column I (where I have dates) need to count them by T8, T9 and T10. Help please Sheila |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting in Excel
Hi
No, that gave me 0, then when I changed 100 to 739 (which is how far the columns go down, I got N/A. By split out, I mean separated so that I have individual counts for each, e.g. T8, 320 T9, 275 T10, 105 "pinmaster" wrote: Not sure what you mean by split out but maybe something like this: =SUMPRODUCT((C1:C100="T9")*(F1:F100="Y")) "Sheila Innes" wrote: I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I have the sum to count each individually. I now need to be able, in column F, to count the Y and N, split out by T8, T9 and T10 (column C). I've tried counta and countif, putting in different parameters but it doesn't work. I also in column H need to count the Y's again split out by T8, T9 and T10 and in column I (where I have dates) need to count them by T8, T9 and T10. Help please Sheila |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting in Excel
#N/A usually means that the ranges are not the same size, or the data
contains #N/A. Either needs to be corrected. Pinmaster's formula was for one specific instance, you would need to have new for each instance. Maybe better to store the test values T8, T9, etc. in say M1:M10 and then in N1 add =SUMPRODUCT(--($C$1:$C$739=M1),--(($F$1:$F$739="Y")) and copy down to get all the answers Or use a pivot table. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sheila Innes" wrote in message ... Hi No, that gave me 0, then when I changed 100 to 739 (which is how far the columns go down, I got N/A. By split out, I mean separated so that I have individual counts for each, e.g. T8, 320 T9, 275 T10, 105 "pinmaster" wrote: Not sure what you mean by split out but maybe something like this: =SUMPRODUCT((C1:C100="T9")*(F1:F100="Y")) "Sheila Innes" wrote: I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I have the sum to count each individually. I now need to be able, in column F, to count the Y and N, split out by T8, T9 and T10 (column C). I've tried counta and countif, putting in different parameters but it doesn't work. I also in column H need to count the Y's again split out by T8, T9 and T10 and in column I (where I have dates) need to count them by T8, T9 and T10. Help please Sheila |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting in Excel
Hi Bob
No that didn't work either. I got an error messge up that there was a fault in the calculation and should they fix it. I said yes and ended up with 0 again. "Bob Phillips" wrote: #N/A usually means that the ranges are not the same size, or the data contains #N/A. Either needs to be corrected. Pinmaster's formula was for one specific instance, you would need to have new for each instance. Maybe better to store the test values T8, T9, etc. in say M1:M10 and then in N1 add =SUMPRODUCT(--($C$1:$C$739=M1),--(($F$1:$F$739="Y")) and copy down to get all the answers Or use a pivot table. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sheila Innes" wrote in message ... Hi No, that gave me 0, then when I changed 100 to 739 (which is how far the columns go down, I got N/A. By split out, I mean separated so that I have individual counts for each, e.g. T8, 320 T9, 275 T10, 105 "pinmaster" wrote: Not sure what you mean by split out but maybe something like this: =SUMPRODUCT((C1:C100="T9")*(F1:F100="Y")) "Sheila Innes" wrote: I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I have the sum to count each individually. I now need to be able, in column F, to count the Y and N, split out by T8, T9 and T10 (column C). I've tried counta and countif, putting in different parameters but it doesn't work. I also in column H need to count the Y's again split out by T8, T9 and T10 and in column I (where I have dates) need to count them by T8, T9 and T10. Help please Sheila |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting in Excel
I had one too many brackets in it, that is why.
Can you post me your workbook? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sheila Innes" wrote in message ... Hi Bob No that didn't work either. I got an error messge up that there was a fault in the calculation and should they fix it. I said yes and ended up with 0 again. "Bob Phillips" wrote: #N/A usually means that the ranges are not the same size, or the data contains #N/A. Either needs to be corrected. Pinmaster's formula was for one specific instance, you would need to have new for each instance. Maybe better to store the test values T8, T9, etc. in say M1:M10 and then in N1 add =SUMPRODUCT(--($C$1:$C$739=M1),--(($F$1:$F$739="Y")) and copy down to get all the answers Or use a pivot table. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sheila Innes" wrote in message ... Hi No, that gave me 0, then when I changed 100 to 739 (which is how far the columns go down, I got N/A. By split out, I mean separated so that I have individual counts for each, e.g. T8, 320 T9, 275 T10, 105 "pinmaster" wrote: Not sure what you mean by split out but maybe something like this: =SUMPRODUCT((C1:C100="T9")*(F1:F100="Y")) "Sheila Innes" wrote: I have a spreadsheet with T8, T9 and T10 in a single column, Column C. I have the sum to count each individually. I now need to be able, in column F, to count the Y and N, split out by T8, T9 and T10 (column C). I've tried counta and countif, putting in different parameters but it doesn't work. I also in column H need to count the Y's again split out by T8, T9 and T10 and in column I (where I have dates) need to count them by T8, T9 and T10. Help please Sheila |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
conditional counting with Excel | Excel Worksheet Functions | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |