COUNTIFS

[tanishmittal]

Hi, need help for the following COUNTIFS function

Basically, want to figure the count of names on basis of how many times the name is in a specific month. You can refer the formula on picture below for clarity. Thanks!

Following is the data table:

Name	Month
A	8
B	8
C	8
D	8
G	8
H	8
A	8
B	8
C	8
F	8
G	8
A	8
C	8
D	8
A	9
B	9
C	9
D	9
E	9
F	9
G	9
H	9
H	9
H	9
H	9
E	9
J	10
K	10
F	10
G	10
J	10
K	10

[atcodedog05 · Accepted solution]

Hi @tanishmittal 

Is this what you looking for

Here is a workflow for the task.

Output:

OR

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[tanishmittal]

Hi @atcodedog05

Slight issue with this as I just want the final count. As you can it mentions "A in 8th month" 3 times with 1, 2 & 3 as the count. I just want the max count in every row. Don't want to summarize it.

[atcodedog05]

Hi @tanishmittal I just rethought that and updated the post.

Happy to help 🙂 @tanishmittal 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[tanishmittal]

Wanted the first output, thanks! 😀

@atcodedog05, the attachment is to an older file, can you send the new file?

[tanishmittal]

A) The attachment is to an older file. Can you attach the newer version considering I want the output similar to output 1.

B) There's another caveat, the table also has another column (for eg: amount) with different amounts for every row field. As a result, I want the count of names on basis of months for every row field. If I summarize, either the amounts go away or it groups by amount making it count "1" for every name.

I hope you understand what I'm saying.

Name	Month	Monthwise Count	Amount
A	8	3	216
B	8	2	149
C	8	3	68
D	8	2	187
G	8	2	44
H	8	1	87
A	8	3	104
B	8	2	286
C	8	3	224
F	8	1	223
G	8	2	80
A	8	3	213
C	8	3	200
D	8	2	90
A	9	1	268
B	9	1	169
C	9	1	277
D	9	1	222
E	9	2	76
F	9	1	109
G	9	1	75
H	9	4	134
H	9	4	61
H	9	4	289
H	9	4	160
E	9	2	189
J	10	2	258
K	10	2	25
F	10	1	35
G	10	1	229
J	10	2	87
K	10	2	106

I want the solution as in third column of this table.

[atcodedog05]

Hi @tanishmittal 

Sorry my bad

Here is the updated workflow.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

[AytajMukhtar]

Hey there, can you please type the steps indicating the tools and formulas used? I was unable to open the attached file. The photos too do not reflect any info