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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count specific text only if adjacent cell is blank?
Hi
With Employee initials in column A, assistants in column B, and BP (the employee to calculate total for) in C2 insert this formula in D2: =SUMPRODUCT(--($A$2:$A$100=C2),--($B$2:$B$100="")) Regards, Per "rumtumtigger" skrev i meddelelsen ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count specific text only if adjacent cell is blank?
What you are doing is a countif with multiple criteria. Since you did not
gieve any cell references I will assume A2:B100 =sumproduct(--(A2:A100 = "BD"), --(B2:B100 = "") Check out this link on sumproduct... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "rumtumtigger" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count specific text only if adjacent cell is blank?
=SUMPRODUCT(--(A1:A100="RS")*(B1:B100=""))
or something similar -- Gary''s Student - gsnu201001 "rumtumtigger" wrote: 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! |
Reply |
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) |