| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
"count if" function based on value of another cell
Hello, (Excel 2003)
Column A contains list of buildings (25+ building names, 1000+ rows) Column D contains a letter indicating if work done ("c") Column E contains text indicating work not done ("n/c") I would like to count the "c"'s grouped by Building name and in a separate cell count the "n/c"'s grouped by Building name. I have tried VLookup with CountIf without any luck. -- Thank-you and all suggestions are appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| How to keep the value of a cell not a function of the other cell | Excel Worksheet Functions | |||
| Can I count in an array based on a function? | Excel Worksheet Functions | |||
| changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Threaded Mode
