| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count entries in one column based on critieria in another c
The data looks like:
State Hours ------ -------- Closed 0.00 Resolved 0.1 cancelled 0.00 Resolved 0.00 etc etc I want to count the number of entries where state = resolved and hours 0.00. -- Thanks, JW |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count entries in one column based on critieria in anotherc
=SUMPRODUCT((A1:A10="Resolved")*(B1:B100))
or =SUM(IF(A1:A10="Resolved")*(B1:B100),1) (CTRL+SHIFT+ENTER this formula as it is an array-formula) adjust ranges to suit pls click YES if this helped On 27 Maj, 07:48, jw wrote: The data looks like: State * * * Hours ------ * * * -------- Closed * * 0.00 Resolved *0.1 cancelled *0.00 Resolved *0.00 etc * * * * * etc I want to count the number of entries *where state = resolved and hours 0.00. * -- Thanks, JW |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count entries in one column based on critieria in another c
=SUMPRODUCT((A3:A6="Resolved")*(B3:B60))
-- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "jw" wrote: The data looks like: State Hours ------ -------- Closed 0.00 Resolved 0.1 cancelled 0.00 Resolved 0.00 etc etc I want to count the number of entries where state = resolved and hours 0.00. -- Thanks, JW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count entries based on criteria in a different column | Excel Worksheet Functions | |||
| count entries based on criteria in a different column | Excel Worksheet Functions | |||
| Deleting Rows based on Column Critieria | Excel Discussion (Misc queries) | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
Linear Mode
