Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting data
Hi All,
I am working in analysis company and I need help in this regard B1 Startup B2 Excess Idle B3 Excess Idle B4 Harsh Braking B5 Speed B6 Harsh Braking B7 Ignition off B8 Startup I need that count of Excess Idle in C1 between B2 to B7, Count of Harsh Braking in D1 between B2 to B7 and speed in E1 between B2 to B7 and delete B7 Thanks & Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting data
Hi Hassan
Checkout Excel's COUNTIF function. For example: =COUNTIF(B1:B8,"Excess Idle") Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Hassan" wrote in message ... Hi All, I am working in analysis company and I need help in this regard B1 Startup B2 Excess Idle B3 Excess Idle B4 Harsh Braking B5 Speed B6 Harsh Braking B7 Ignition off B8 Startup I need that count of Excess Idle in C1 between B2 to B7, Count of Harsh Braking in D1 between B2 to B7 and speed in E1 between B2 to B7 and delete B7 Thanks & Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Data | Excel Discussion (Misc queries) | |||
Counting data | Excel Discussion (Misc queries) | |||
Counting Data | Excel Worksheet Functions | |||
Counting Data | New Users to Excel | |||
Data counting | Excel Discussion (Misc queries) |