| View previous topic :: View next topic |
| Author |
Message |
Guest
|
 Posted: Tue Dec 02, 2003 7:02 am Post subject: How to use jolly characters in SUMIF function |
 |
|
like in Excel .. I have some formulas imported from an excel datasheet who works in Excel.
I want to use a formula like =SUMIF(A1:A100;"example*";B1:B100) to search & sum B column for every occurence of any words starting with example in the A column
OOo seems not understanding the meaning of the "*" character .. there's a way to solve this problem, like modifying or using another formula?
Tnx a lot |
|
| Back to top |
|
 |
Guest
|
| Posted: Thu Dec 11, 2003 2:40 am Post subject: |
|
|
| do someone can help me using wildcards in in this kinfd of function?? |
|
| Back to top |
|
|
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Thu Dec 11, 2003 4:19 am Post subject: |
|
|
From the HELP on SUMIF ....
SUMIF
Adds the cells specified by a given criteria. This function is used to browse a range when you search for a certain value.
The search supports regular expressions. As soon as you have entered text, you can enter "all.*", for example to find the first location of "all" followed by any characters.
There is a detailed piece on usage of regular expressions as well |
|
| Back to top |
|
|
|
