SUM

[Guest]

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 ?

 

[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

 

[Bob Phillips]

=COUNTIF(A:A,"porto")

--
HTH

Bob Phillips

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

 

[Guest]

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

 

[Guest]

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

 

[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

 

[Bill Ridgeway]

That's better than my suggestion!!

Regards.

Bill Ridgeway
Computer Solutions

 

[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)

 

[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)

 

[Bob Phillips]

he said he had domains, not email addresses!

--
HTH

Bob Phillips

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

 

[Ragdyer]

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