**Question description:**

*This user has given permission to use the problem statement for this blog.*

i need a formula to combine column y with the number mentioned in column w counting in from 1 to 0 and posting the total count next to number 1 in column v.

Solved by E. J. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
22/08/2018 - 06:45

Welcome, Thanks for choosing Got It Pro-Excel.

Excelchat Expert
22/08/2018 - 06:46

Do you have sample data that we can work with?

User
22/08/2018 - 06:49

here is an example

[Uploaded an Excel file]

Excelchat Expert
22/08/2018 - 06:51

Okay.

Excelchat Expert
22/08/2018 - 06:51

How would you like to combine the columns?

Excelchat Expert
22/08/2018 - 06:55

Hello, are you there?

User
22/08/2018 - 06:56

i would like to combine column w or y to column v for every similar email sent. without counting it manually

User
22/08/2018 - 06:57

i was counting manually from 1 to 0 and the first email sent gmail. com was 3 and put the total next to one

User
22/08/2018 - 06:58

so, 1,0,0 = count 3

User
22/08/2018 - 06:59

and the next count was for email on column x ( omcast.net which was 1,0,0,0,0,0,0,0,0,0 = count 10 next to 1.

Excelchat Expert
22/08/2018 - 07:01

Basically, why are you doing all these? Maybe there is a better approach to this.

Excelchat Expert
22/08/2018 - 07:01

Please let me know

User
22/08/2018 - 07:03

i am trying to find a formula

User
22/08/2018 - 07:03

instead of counting it manually

User
22/08/2018 - 07:03

i have over 60000, i cant do them all manually

Excelchat Expert
22/08/2018 - 07:04

Very good.

Excelchat Expert
22/08/2018 - 07:04

What do you want to count?

User
22/08/2018 - 07:04

column w for each email sent

Excelchat Expert
22/08/2018 - 07:05

1 implies an email sent?

User
22/08/2018 - 07:05

and total will be posted on column v beside the number 1

User
22/08/2018 - 07:06

# opens Uniques
3 1 @gmail.com
0 @gmail.com
0 @gmail.com

User
22/08/2018 - 07:07

# opens Uniques
3 1 @gmail.com
0 @gmail.com
0 @gmail.com

User
22/08/2018 - 07:09

here is an example. so, 3 gmail.com were sent and the total count is 3. i want to figure out a formula that count the 3 gmail.com email into column v next to number 1 on column w or y

Excelchat Expert
22/08/2018 - 07:11

Are columns W and Y always the same? Or sometimes their rows change?

User
22/08/2018 - 07:12

they are the same because it is the same emails from the same firms. the only thing that changes is numbers of email sent per firm

Excelchat Expert
22/08/2018 - 07:13

Okay.

User
22/08/2018 - 07:14

here is an example formula i was using = COUNT(W12,1,0)

User
22/08/2018 - 07:19

please see new excel sheet just uploaded for you. so, you can have an idea of what am saying

[Uploaded an Excel file]

Excelchat Expert
22/08/2018 - 07:20

Okay.

Excelchat Expert
22/08/2018 - 07:21

Okay. Working on this...

User
22/08/2018 - 07:24

thank you

User
22/08/2018 - 07:44

ANY PROCESS

User
22/08/2018 - 07:44

LOOKS LIKE I GOT 37 SECOND LEFT

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*