Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting by group
For the following data,
decision Base <50 50-60 60-70 70 FN 20.632 1 0 0 0 FN 34.492 1 0 0 0 FN 37.398 1 0 0 0 FP 65.422 0 0 1 0 FP 161.897 0 0 0 1 FP 102.764 0 0 0 1 FP 90.76 0 0 0 1 FN 10.738 1 0 0 0 FP 151.7 0 0 0 1 is there any quick way that i can ask excel to derive the statistics just below? decision <50 50-60 60-70 70 FN 4 0 0 0 FP 0 0 1 4 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting by group
Assuming the results table is in L1:Pn, in M2 enter
=SUMIF($A:$A,$L2,C:C) and copy across and down. -- __________________________________ HTH Bob "ela" wrote in message ... For the following data, decision Base <50 50-60 60-70 70 FN 20.632 1 0 0 0 FN 34.492 1 0 0 0 FN 37.398 1 0 0 0 FP 65.422 0 0 1 0 FP 161.897 0 0 0 1 FP 102.764 0 0 0 1 FP 90.76 0 0 0 1 FN 10.738 1 0 0 0 FP 151.7 0 0 0 1 is there any quick way that i can ask excel to derive the statistics just below? decision <50 50-60 60-70 70 FN 4 0 0 0 FP 0 0 1 4 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting by group
"Bob Phillips" wrote in message ... Assuming the results table is in L1:Pn, in M2 enter =SUMIF($A:$A,$L2,C:C) and copy across and down. -- __________________________________ HTH Bob it seems you are using array formula...? What's Pn? and $L2 are the condition criteria, what are they...? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting by group
No, it is not an array formula, just a standard formula.
Pn is column P, down to some indeterminate row, n, that only you know. $L2 is the decision value being tested, FN in row 2, FOP in row 3, etc. -- __________________________________ HTH Bob "ela" wrote in message ... "Bob Phillips" wrote in message ... Assuming the results table is in L1:Pn, in M2 enter =SUMIF($A:$A,$L2,C:C) and copy across and down. -- __________________________________ HTH Bob it seems you are using array formula...? What's Pn? and $L2 are the condition criteria, what are they...? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting or summing up a group of cells with dates as datas | Excel Discussion (Misc queries) | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |