| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need the correct formula
I am trying to count all the cells in a table that have a Category (first
column)of 'data' and a Priority (second column) of 'medium'. I can get a count of all the cells with a value of 'medium' by using the 'CountIf' function. But I can't seem to further restrict the count to just 'data' and 'medium'. I've tried the If-And function without sucess. Thanks in advance -- Rob K |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please Correct the formula | Excel Discussion (Misc queries) | |||
| what is the correct formula to add a column with =sum | New Users to Excel | |||
| How do I correct this formula? | Excel Worksheet Functions | |||
| What's the correct formula? | Excel Discussion (Misc queries) | |||
| How I need correct formula, that no t rounding? | Excel Worksheet Functions | |||
Threaded Mode
