Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
dela_dela pe Simpatie.ro
 | Femeie
24 ani
Bucuresti
cauta Barbat
24 - 48 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
Source:
https://exceljet.net/formula/count-if-t ... eria-match
Count if two criteria match
Generic formula:
=COUNTIFS(range1;critera1;range2;critera2)
Example (see link above):
=COUNTIFS(B4:B11;"blue";C4:C11;">15")
**********************
SUMPRODUCT alternative
You can also use the SUMPRODUCT function to count rows that match multiple conditions. the equivalent formula is:
=SUMPRODUCT((B4:B11="Blue")*(C4:C11>15))
SUMPRODUCT is more powerful and flexible than COUNTIFS, and it works with all Excel versions, but it is not as fast with larger sets of data.
**********************
Pivot table alternative
If you need to summarize number of criteria combinations in a larger data set, you should consider pivot tables. Pivot tables are a fast and flexible reporting tool that can summarize data in many different ways. For a direct comparison of SUMIF and Pivot tables, see this video: https://exceljet.net/plc/why-pivot-tables
|
|
| |
|
