Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting formula
A B
1 Bob 3 2 Bob 10 3 Sue 10 7 8-13 13-20 Bob 1 1 0 Sue 0 1 0 Jeff 0 0 0 Based on the first table, I would like a formula in the second table that calculates how many of their numbers fall into the specific categories of 7, 8-13, etc. THANK YOU |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting formula
=SUMPRODUCT(--(A1:A100="Bob"),--(B1:B1007))
=SUMPRODUCT(--(A1:A100="Bob"),--(B1:B100=8),--(B1:B100<=13)) "TMF in MN" wrote: A B 1 Bob 3 2 Bob 10 3 Sue 10 7 8-13 13-20 Bob 1 1 0 Sue 0 1 0 Jeff 0 0 0 Based on the first table, I would like a formula in the second table that calculates how many of their numbers fall into the specific categories of 7, 8-13, etc. THANK YOU |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting formula
Try something like this:
With A1:B3 contains your sample data Then enter these values in A6:D7 Low 7 8 14 High 999999 13 20 And these values in A9:D9 Name 7 8 - 13 14 - 20 AND...A10:A12 Bob Sue Jeff Next: B10: =SUMPRODUCT(($A$1:$A$3=$A10)*($B$1:$B$3=B$6)*($B$ 1:$B$3<=B$7)) Copy that formula across and down thru D12 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "TMF in MN" wrote: A B 1 Bob 3 2 Bob 10 3 Sue 10 7 8-13 13-20 Bob 1 1 0 Sue 0 1 0 Jeff 0 0 0 Based on the first table, I would like a formula in the second table that calculates how many of their numbers fall into the specific categories of 7, 8-13, etc. THANK YOU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Different Names in A Column... Formula? | New Users to Excel | |||
Subtotal counting formula in cells | Excel Discussion (Misc queries) | |||
FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,000 | Excel Worksheet Functions | |||
Counting Formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions |