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:
Roxxxi23 Profile
 | Femeie
23 ani
Neamt
cauta Barbat
23 - 52 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2189
|
|
1. If you compare with a cell having the exact text string
Assuming in column A1 to A10 you have a set of numbers and in column B1 to B10 you have certain text strings.
In order to sum up the numbers in column A corresponding to certain text in column B you need this formula:
=SUM(IF(B6:B10="text string";A1:A10))
This is an array formula so invoke the formula by hitting:
CONTROL+SHIFT+ENTER
Source:
2. If you look only for some text in the cell
To sum up values based only a part of the text, use:
=SUMIF(C4:C19;"*text string*";D4:D19)
Note the * before and after the text string.
The SUMIF function supports wildcards. An asterisk (*) means "one or more characters", while a question mark (?) means "any one character".
These wildcards allow you to create criteria such as "begins with", "ends with", "contains 3 characters" and so on.
To match all items that contain "text string", the criteria is "*text string*". Note that you must enclose literal text and the wildcard in double quotes ("").
Source:
_______________________________________
|
|
| pus acum 9 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
More sources:
Alternative with SUMIFS
You can also use the SUMIFS function. SUMIFS can handle multiple criteria, and the order of the arguments is different from SUMIF. The equivalent SUMIFS formula is:
=SUMIFS(D5:D11,C5:C11,"*t-shirt*")
Notice that the sum range always comes first in the SUMIFS function.
|
|
| pus acum 6 ani |
|