OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to use jolly characters in SUMIF function

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Guest






PostPosted: Tue Dec 02, 2003 7:02 am    Post subject: How to use jolly characters in SUMIF function Reply with quote

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






PostPosted: Thu Dec 11, 2003 2:40 am    Post subject: Reply with quote

do someone can help me using wildcards in in this kinfd of function??
Back to top
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Thu Dec 11, 2003 4:19 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group