Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
count if one column
I am brain dead...I cannot remember how to count value in one column if
another coulmn meets a certain criteria. For instance I want to count all the "NO" in columns D & E, but only if column B is Annex Heather Annex Business Services NO NO Enedina Stock Storekeeper 1 NO Thomas JCW Operator 0 1 Arnold Fuel Fuel Handling 0 0 David K12 Maintenance 0 NO Eric K12 Operator 0 0 Gary K12 Maintenance 0 NO Tammy K12 Maintenance 0 NO Chris JCW Maintenance 1 NO Frank K34 Maintenance 1 NO Craig Fuel Fuel Handling 0 1 Kenneth JCW Technical Business 0 NO Alfredo JCW Operator 0 0 Michael JCW Maintenance 0 NO Kurt K12 Operator 1 1 Tara Stock 0 NO Mark Fuel Fuel Handling 0 0 Lukus Fuel Fuel Handling 0 1 Marty Annex Business Managers 0 0 -- Krista |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Count entries in one column based on values in another column | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions |