Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel count problem
as you can see below here i have tow cloumn i want to count the reeferin a
cel from one first colum butt i don,t want to count that reefer which is not belong to PV (second column).as like i at other cel i just want to count Equate Reefer not PV. can any one help me colum 1 Type Project Reefer PV Reefer Equate Reefer PV Reefer Equate Reefer PV |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel count problem
Put this in C1:
=COUNTIF(B:B,"Equate") Hope this helps. Pete On Apr 27, 7:17*pm, Suleman wrote: as you can see below here i have tow cloumn i want to count the reeferin a cel from one first colum butt i don,t want to count that reefer which is not belong to PV (second column).as like i at other cel i just want to count Equate Reefer not PV. can any one help me colum 1 Type * * * * * * * * * * * * * * * * * * * *Project Reefer * * * * * * * * *PV * * * * * * * Reefer * * * * * * * * *Equate * * * * * Reefer * * * * * * * * *PV * * * * * * * Reefer * * * * * * * * *Equate * * * * * Reefer * * * * * * * * *PV * * * * * * * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with COUNT | Excel Discussion (Misc queries) | |||
COUNT IF (AND / OR) SUM IF PROBLEM | Excel Worksheet Functions | |||
count problem | Excel Worksheet Functions | |||
Count IF problem | Excel Worksheet Functions | |||
count problem | Excel Worksheet Functions |