| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
