COUNTIF Alternative for multiple criteria?
I have been searching posts all morning to find an answer to my problem, but no luck so far.
I have 2 worksheets, on 1 is a dump of data (Sheet 2) and on the other (Sheet 1) is a list of names (100's). Because I know that within the name column in the dump of data there could be various spellings of the same name i.e. Christopher Smith and Chris Smith, I have 2 columns (A and B) in Sheet 2 with the alternative spelling of the name.
I want to count, on Sheet 1 how many times either name in column A or B , appears on the name column in Sheet 2. I want to be able to copy the formula down so that it updates for each row in Sheet 1, to take account for the new name in each row.
I don't think this can be done with COUNTIF, but I need to count using two criteria:
The two criteria a
1) A8:A100 > 1/1/08
2) G8:G100 <> ""
In order to get a unique count, I use the formula below sometimes:
Using this I get counts based on the occurrence in the data as of a certain row rather than a total i.e. 1,2,3,4 for four similar values rather than 4,4,4,4. However, this is an incredible expensive formula, particularly in 2010. To drag down and paste values requires time that I just don't want to wait.
Can someone suggest an alternative formula that accomplishes the same task?
I'm trying to create a COUNTIF function for multiple columns and one criteria.
For example, the range is column X, AD, AJ, AP, and AV with the criteria if the cell says "Pending." I'm trying to create a summary to count how many cells in each of those columns says pending. Also, the summary is on a different worksheet tab than the data. I've tried a few different formulas, but none of them seem to work.
Related Applications & Scripts
Kingsoft Office 2010 offers a robust set of features for you to create professional documents with. It contains three essential office applications: Kingsoft Writer, Kingsoft Presentation, and Kingsoft Spreadsheets - all with a familiar interface and user-friendly functions. No re-learning process is required. With its strong compatibility with a variety of file formats, Kingsoft Office 2010 is the best alternative to Microsoft Office.
- Present your documents more easily
- Communicate with your clients easily
- Supports various operating systems including Windows 7
- Built-in PDF export
- Compact file size, fast operation
If you are looking for free alternative to Google Translate API and you don’t want to pay for translations this PHP class will solve your translation problems and needs.
If you have a mod_rewrite using web-project and your server doesnt support mod_rewrite you should usually turn the friendly urls in your documents into ugly ones, and this could take time.
Kingsoft PowerWord is a collection of Chinese, English and bilingual dictionaries and supporting proprietary software.
The newest PowerWord 2010 Oxford edition not only provides the most comprehensive database for Chinese-English two-way translation needs, but also incorporates 7 language dictionaries to support multi-language speakers. New features include: Audio pronunciations for 320,000 entries, 200,000 sentences searches, multilingual text and website translation, newly built OCR in cursor translator, etc. That is why PowerWord is used all over the world by more than 20 million people.
Lanapsoft (formerly Lanap) BotDetect CAPTCHA is an awarded website security solution using Captcha challenges to prevent automated page posting. Bots are kept from accessing protected website functionality using Captcha images specifically designed to be out of reach of computer vision and OCR technologies. BotDetect also provides a sound Captcha alternative to keep websites accessible to people with impaired vision.
BotDetect is unique among Captcha solutions in offering many Captcha image and sound styles. While each of them is easily comprehensible to human users, randomly using multiple Captcha generation algorithms makes the Captcha challenge practically impossible to pass automatically.