Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf
my data look like this:
Date MS% 3-Jan 6.16% 4-Jan 5.87% 5-Jan 2.60% 8-Jan 5.89% 9-Jan 3.80% 10-Jan 4.42% 11-Jan 5.34% 12-Jan 5.49% 16-Jan 4.00% 17-Jan 5.28% 18-Jan 4.84% 19-Jan 5.26% I am trying to find a formula for the table below (count the number of time colB above is between 0 and 1%, 1 and 2%, 3 and 4% 0 to 1% 1 to 2% 2 to 3% 0 0 1 Thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
countif | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |