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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Popa Bianca la Simpatie.ro
 | Femeie
25 ani
Valcea
cauta Barbat
25 - 63 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Source:
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:
|
|
| pus acum 7 ani |
|