SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[excel] Count if two criteria match - EXCEL formula

I have this table and I would like to create a formula which would count values based on true conditions from column A and column C.

Example: If in column A value is M (male), and in column C is YES, then it would count.

could anyone help me with this formula?

table

This question is related to excel excel-formula

The answer is

If youR data was in A1:C100 then:

Excel - all versions

=SUMPRODUCT(--(A1:A100="M"),--(C1:C100="Yes"))

Excel - 2007 onwards

=COUNTIFS(A1:A100,"M",C1:C100,"Yes")

Source: Stackoverflow.com

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to excel-formula

• Excel doesn't update value unless I hit Enter • Referencing value in a closed Excel workbook using INDIRECT? • Conditionally formatting cells if their value equals any value of another column • Sum values from multiple rows using vlookup or index/match functions • What does an exclamation mark before a cell reference mean? • If two cells match, return value from third • Excel - programm cells to change colour based on another cell • Format numbers in thousands (K) in Excel • Excel Formula which places date/time in cell when data is entered in another cell in the same row • Excel formula to display ONLY month and year?