SUM

F

Fire

How can i get, in one cell, the number of cells with some condicions like
"porto" ?

I want the sum of cell with the word porto. how can i do this ?
 
B

Bill Ridgeway

You will need a helper column in which there is the formula -
=IF(ISNUMBER(SEARCH("porto",A1)),1,0)
which will return 1 when the target word is found

You will then only need to sum the column.

Regards.

Bill Ridgeway
Computer Solutions
 
B

Bob Phillips

=COUNTIF(A:A,"porto")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
F

Fire

m8, tks for your answer, but i explained me wrong... this i can do with
automatic filters i guess.

the question is:
suppose i have from A1 to A1000 lot of domains, and each domain can appear
more than 1 time.
What i want is some kind of function that could go from a1 to a1000 and give
me the sums to each domain in that cells.

My entreprise received, in july, 50000 mails and i am studing what can i do
to fight against the spammers.

Joseph
 
F

Fire

m8, tks for your answer, but i explained me wrong... this i can do with
automatic filters i guess.

the question is:
suppose i have from A1 to A1000 lot of domains, and each domain can appear
more than 1 time.
What i want is some kind of function that could go from a1 to a1000 and give
me the sums to each domain in that cells.

My entreprise received, in july, 50000 mails and i am studing what can i do
to fight against the spammers.

Joseph
 
K

kounoike

assuming data is populated in A1:A5
=SUMPRODUCT(--ISNUMBER(SEARCH("porto",A1:A5)))
but this will count the sum of cells with the word contaning "porto", like
"*porto*".

keizi
 
B

Bill Ridgeway

That's better than my suggestion!!

Regards.

Bill Ridgeway
Computer Solutions
 
B

Bob Phillips

COUNTIF will do that, just put it alongside the A cells.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

RagDyeR

BUT ... if "porto is just a *part* of an e-mail address, try this:

=COUNTIF(A:A,"*porto*")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


COUNTIF will do that, just put it alongside the A cells.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

he said he had domains, not email addresses!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

Ragdyer

Ah, yes ... my mistake ... BUT ... domains are not domains without an
extension!<g>
 
Top