| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) | |||
| Formula to combine text? | Excel Worksheet Functions | |||
| Formula to get Relative Folder Reference to data in another file? | Excel Worksheet Functions | |||
| help keeping the worksheet names within formula | Excel Worksheet Functions | |||
| Combine VLOOKUP, IF, AND in one formula | Excel Worksheet Functions | |||
Linear Mode
