Combine several Names in one folder with if-formula

[Vic1978]

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

 

[Bob Phillips]

Do you mean

=SUMIF(A:A,"[email protected]",B:B)

--

HTH

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

 

[JMay]

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

 

[Vic1978]

Hello

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

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

Regards
Vicky

 

[JMay]

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