Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count specific text only if adjacent cell is blank?
Hi all,
I have a spreadsheet with several different employee initials in one cell and sometimes assistant name in the next cell if someone helped them on a project. I want to count the cells of the employee BP only if the cell next to it is blank and they managed the project themselves. Then I want to go to a different totals cell and put in a formula to count employee RS who managed the project alone... etc. etc. I tried using IFBLANK but I am a bit of a novice can't quite figure this out! Any help would be appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop text displaying in blank adjacent cells? | Excel Discussion (Misc queries) | |||
Search for specific text within last non blank cell in a range | Excel Worksheet Functions | |||
how to prevent text overflow into adjacent blank cells | Excel Discussion (Misc queries) | |||
how do i count specific text strings excluding blank cells? | Excel Worksheet Functions | |||
count by specific text color in range of cell | Excel Discussion (Misc queries) |