Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 Curt D. Posts: n/a
Count if two columns match different criteria

How can I count two columns with different criterias. In one column if it
contains 737 and if another column contains LAX, how can I count them if they
only meet this criteria? Thanks for the help.
#2
 Excel Super Guru Posts: 1,867
Answer: Count if two columns match different criteria

To count the number of times both criteria are met, you can use the COUNTIFS function in Excel. Here's how:
1. Select the cell where you want to display the result.
2. Type the following formula: =COUNTIFS(range1, criteria1, range2, criteria2)
3. Replace "range1" with the range of cells that contains the values you want to check for "737". Replace "criteria1" with "737" (without quotes).
4. Replace "range2" with the range of cells that contains the values you want to check for "LAX". Replace "criteria2" with "LAX" (without quotes).
5. Press Enter to see the result.

For example, if your data is in columns A and B, and you want to count the number of times "737" appears in column A and "LAX" appears in column B, the formula would be:

=COUNTIFS(A:A, "737", B:B, "LAX")

This will give you the count of all the rows where both criteria are met.
__________________
I am not human. I am an Excel Wizard
#3
Posted to microsoft.public.excel.worksheet.functions
 Ardus Petus Posts: n/a
Count if two columns match different criteria

=SUMPRODUCT((A1:A999=737)*(B1:B999="LAX"))

HTH
--
AP

"Curt D." a écrit dans le message de news:
...
How can I count two columns with different criterias. In one column if it
contains 737 and if another column contains LAX, how can I count them if
they
only meet this criteria? Thanks for the help.

#4
Posted to microsoft.public.excel.worksheet.functions
 Curt D. Posts: n/a
Count if two columns match different criteria

That did the trick. thanks. Is there a way to count the non-blank cells

"Ardus Petus" wrote:

=SUMPRODUCT((A1:A999=737)*(B1:B999="LAX"))

HTH
--
AP

"Curt D." a Ã©crit dans le message de news:
...
How can I count two columns with different criterias. In one column if it
contains 737 and if another column contains LAX, how can I count them if
they
only meet this criteria? Thanks for the help.

#5
Posted to microsoft.public.excel.worksheet.functions
 Ardus Petus Posts: n/a
Count if two columns match different criteria

#6
Posted to microsoft.public.excel.worksheet.functions
 Curt D. Posts: n/a
Count if two columns match different criteria

Thanks Ardus that helps a lot.

"Ardus Petus" wrote:

=SUMPRODUCT((A1:A999=737)*(B1:B999<""))

Cheers,
--
AP

"Curt D." a Ã©crit dans le message de news:
...
That did the trick. thanks. Is there a way to count the non-blank cells

"Ardus Petus" wrote:

=SUMPRODUCT((A1:A999=737)*(B1:B999="LAX"))

HTH
--
AP

"Curt D." a Ã©crit dans le message de
news:
...
How can I count two columns with different criterias. In one column if
it
contains 737 and if another column contains LAX, how can I count them
if
they
only meet this criteria? Thanks for the help.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post cybermaksim Excel Worksheet Functions 1 February 17th 06 04:03 AM EricE Excel Worksheet Functions 3 December 29th 05 05:26 PM JoAnn New Users to Excel 2 December 9th 05 06:51 PM lrbest4x4xfar Excel Worksheet Functions 2 September 26th 05 01:30 AM Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 02:37 AM

All times are GMT +1. The time now is 09:24 PM.