LinkBack URL
About LinkBacks
Example attached. I have a formula in E2 that is wrong. It is counting all the blank cells in column A and should only be counting the blank cells in column A that have "PACIFIC" listed in column B.
Example attached. I have a formula in E2 that is wrong. It is counting all the blank cells in column A and should only be counting the blank cells in column A that have "PACIFIC" listed in column B.
try
=COUNTIFS(A:A,"",B:B,D2)
and copydown
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or
=SUMPRODUCT(--(A2:A11=""))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Formula:
=SUMPRODUCT(($B$2:$B$11=D2)*($A$2:$A$11=""))
Alternative
Punnam
Thank you Wayne & Punnam for taking the time to look at my problem. Both those formulas worked. Now I need to figure out how to mark it as solved.
Amy
your welcome
see my signature shows how to add reputation and to mark solved
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks