Combine several Names in one folder with if-formula
 

Hello,

how is it possible to calculate with the same Content (e.g.Emailadress
exists 5 times) and to sum up the revenue which are made through this
emailadress?
Is it possible with the if-formula?

Thanks
vicky


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=491409

Combine several Names in one folder with if-formula
 

Do you mean

",B:B)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Vic1978" wrote in
message ...

Hello,

how is it possible to calculate with the same Content (e.g.Emailadress
exists 5 times) and to sum up the revenue which are made through this
emailadress?
Is it possible with the if-formula?

Thanks
vicky


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=491409

Combine several Names in one folder with if-formula
 

Maybe
=sumif(YourRngofEmails,"Vic978.com",YourRngOfReven ues)
=sumif($A$2:$A$100,"Vic1978.com",$H$2:$H$100)



"Vic1978" wrote in
message ...

Hello,

how is it possible to calculate with the same Content (e.g.Emailadress
exists 5 times) and to sum up the revenue which are made through this
emailadress?
Is it possible with the if-formula?

Thanks
vicky


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=491409

Combine several Names in one folder with if-formula
 

Hello

Thanks for the advise, it works ;)
but you have to use ";" instead of ","

=SUMIF(A:A;$A7;K:K)

Regards
Vicky


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=491409

Combine several Names in one folder with if-formula
 

Thanks for feedback;
In USofA it's ","
Jim


"Vic1978" wrote in
message ...

Hello

Thanks for the advise, it works ;)
but you have to use ";" instead of ","

=SUMIF(A:A;$A7;K:K)

Regards
Vicky


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=491409