You are here: HomeExcelTutorials

# Using COUNTIFS with multiple columns

## Using COUNTIFS with multiple columns

Price: FREE

I am trying to count a number of items where certain conditions apply. The first 4 conditions are single columns looking for a specific value. The last condition is searching 12 columns to find values less than a certain amount.
Individually, these 2 formulas work:
=COUNTIFS(WaterNoDup!\$D\$5:\$D\$1500,\$AC\$7,WaterNoDup!\$E\$5:\$E\$1500,\$AC\$8,WaterNoDup!\$F\$5:\$F\$1500,\$AC \$9,WaterNoDup!\$K\$5:\$K\$1500,\$AC\$10)
=COUNTIFS(WaterNoDup!\$R\$5:\$AC\$1500,C9)
Together like below, they return a #VALUE answer.
=COUNTIFS(WaterNoDup!\$D\$5:\$D\$1500,\$AC\$7,WaterNoDup!\$E\$5:\$E\$1500,\$AC\$8,WaterNoDup!\$F\$5:\$F\$1500,\$AC \$9,WaterNoDup!\$K\$5:\$K\$1500,\$AC\$10,WaterNoDup!\$R\$5:\$AC\$1500,C9)

Visit publisher's web-site: Using COUNTIFS with multiple columns

Category and Tags: ExcelTutorials :

## Related Tutorials

### Multiple CountIfs?

Free: Yes
Tags: Excel ›

I have a large sheet of 800,00 rows and about 50 columns.
Some of these rows have the same values in certain cells as other rows. I want to be able to identify the duplicates by certain columns.
ie, if the data in column A, D, F and R is the same as another row, it should be marked as a duplicate.
I hope this makes sense. I can find duplicates in one column by using a countif and then counts of 2 or more are duplicates. But I don't know how to bring in other columns to the calculations, can I use 2 countifs in the same calc?

### Countifs for multiple conditions

Free: Yes
Tags: Excel ›

I have attached an excel sheet with two questions to set up a countifs formula for multiple conditions. I have tried to explain it fully in the attachment if anyone would be kind enough to look at it.

### Multiple If countifs

Free: Yes
Tags: Excel ›

I'd like to use multiple if countifs, I tried a couple of formulas and even though the formulas work I keep getting the wrong results.
I've tried the following:
=IF(COUNTIFS(D4:E4,CHAR(251))+COUNTIFS(O4:P4,CHAR(252)),CHAR(251),CHAR(252))
=IF(AND(COUNTIFS(D4:E4,CHAR(251),O4:P4,CHAR(252)),CHAR(251),CHAR(252))
What's the problem with the above?

### Using "IF" function within a "COUNTIFS" function

Free: Yes
Tags: Excel ›

I am wondering how to use an IF function nested within a COUNTIFS function, or if this is even possible. Specifically, I have three columns of data - Team, Points For, Points Against. Then, each row represents a "game". So team "XYZ" will have multiple rows of data.
I am trying to consolidate the info into a new sheet with again three columns, but this time they are as follows: Team, Wins, Losses. However, there would only be one row per team.
Can I use COUNTIFS to return the number of times a given Team's "Points For" value is greater than its "Points Against" value, thus giving me total number of wins?
All I can think to do is somehow nest an IF function within the COUNTIFS function (which I have been unable to figure out so far), but maybe I am just way off in the first place.

### Countifs for multiple worksheets

Free: Yes
Tags: Excel ›

Can the countifs function be used to count cells across multiple worksheets? I keep getting a #VALUE! error. I have tried changing the format of the cells in question but I cannot resolve the error.

## Related Applications & Scripts

### jQuery Mega Menu - Drop down menu

Free: Yes

Mega Menus refer to drop down menus that contain multiple columns of links. This jQuery script lets you add a mega menu to any anchor link on your page, with each menu revealed using a sleek expanding animation. Customize the animation duration plus delay before menu disappears when the mouse rolls out of the anchor.

### PHP Contact Form - Multiple E-Mail

Free: No
Tags: Flash › Excel Emailing Forms

PHP Contact Form, Multiple E-Mail. Flash PHP contact form XML driven, which means you can easily edit settings like company name, emails, description.

### Multiple Distance & Direction Calculator

Free: No
Tags: JavaScript › Excel Calculators

Calculate Distance between Multiple Locations at once using Google MAP API .
Features :
1. Easy to integrate
2. Supports Multiple Locations (more than 2 locations)
3. Auto generate addresses into Textbox when typed
4. Uses Google Ajax call, so no Page load is required
5. Added JQuery to make the code more easy to integrate
6. Smaller layout, so that we can use it as widget.
7. Only HTML & Javascript knowledge required

### Image Wheel - Multiple Image Uploader

Free: No
Tags: PHP › Excel Upload Systems

Multiple image uploader that is easy to install and use. The demo only allows to upload images smaller than 200kb. Please note that the images in our demo have been uploaded by viewers and may contain nudity or disturbing images.
If you like our updates then please consider re-purchasing the item.

### AutoShrinker - Automatically shrink multiple links

Free: No
Tags: PHP › Excel URL Based

AutoShrink is a special PHP Class that enables you to automatically shrink multiple links in a text with a specific url shrinking website. AutoShrink contains so far 15 different websites to shrink with. AutoShrink also lets you to add new websites to the script easy as possible!.
Features:
Adfly, Bitly, Googl, Isgd, Jmp, Snim, Snipr, SnipURL, Snurl, TinyURL, Xrlus, Twirl, Kattit, MeeLa, IamFlyin