Question posted 2011 · +7 upvotes
I have two columns with data:
A B
1 HELIOS AU
2 HELIOS
3 HELIOS AU
4 SPARTA
5 HELIOS AU
Countif(A..;"HELIOS") AND Countif(B..;"AU")
I can count the amount of HELIOS or SPARTA in a column. But how can I count the amount of AU per HELIOS or SPARTA?
Accepted answer +15 upvotes
Use COUNTIFS to count with multiple criteria, e.g.
=COUNTIFS(A:A, "SPARTA", B:B, "AU")
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
— top 25%.