Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Only Countif when a defined cell is not filled.

Posted on 2012-03-25
1
263 Views
Last Modified: 2012-06-21
I wish to setup a mechanism to count the number of x's in a series of cells but only if another cell does not have an x in it.

So, for example;

If Cell A1 has an x (or whatever) in it, then it will not count the number of x's in the cells B1 thru B10.

If Cell A1 does not have an x (or whatever) in it, then it will count the number of x's in the cells B1 thru B10.

Thanks

Richard
0
Comment
Question by:VeeBeeSix
1 Comment
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 37762698
Try using an IF function like this

=IF(A1="x","",COUNTIF(B1:B10,"x"))

That returns a blank [""] if A1 has an "x", otherwise the count of "x"s in B1:B10, is that what you need?

regards, barry
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question