Formula Help Needed.

[DarrenF]

If I want to count how many days someone worked based off the name in column B and the Day of the Month in Column C what kind of formula would I need?

A B C Ticket Number Name Day of the Month 11501679 Jimmy Johns 2 11514116 Jimmy Johns 2 11514524 Jimmy Johns 2 11514782 Jimmy Johns 2 11515051 Jimmy Johns 3 11515282 Jimmy Johns 4 11515549 Jimmy Johns 4 11516527 Jimmy Johns 4 11517261 Jimmy Johns 5 11520796 Jimmy Johns 5 11520849 Jimmy Johns 5 11524429 Jimmy Johns 6 11525140 Jimmy Johns 6 11525675 Jimmy Johns 6 11525787 Jimmy Johns 9 11527125 Jimmy Johns 9 11527223 Jimmy Johns 9 11389189 Magic Johnson 10 11392994 Magic Johnson 10 11393375 Magic Johnson 10 11393776 Magic Johnson 10 11394171 Magic Johnson 10 11396216 Magic Johnson 11 11397851 Magic Johnson 11 11398554 Magic Johnson 11 11398898 Magic Johnson 11 11399327 Magic Johnson 11 11399546 Magic Johnson 11 11400425 Magic Johnson 11 11406878 Magic Johnson 11 11406966 Magic Johnson 11 11407147 Magic Johnson 11 11408630 Magic Johnson 11 11409083 Magic Johnson 12 11409302 Magic Johnson 12 <colgroup><col span="3"></colgroup><tbody> </tbody>

<colgroup><col span="3"></colgroup><tbody>
</tbody>

 

[sandy666]

try PowerQuery

Name	Day of the Month	Days		Name	Days
Jimmy Johns	2​	4​		Jimmy Johns	17​
Jimmy Johns	3​	1​		Magic Johnson	18​
Jimmy Johns	4​	3​
Jimmy Johns	5​	3​
Jimmy Johns	6​	3​
Jimmy Johns	9​	3​
Magic Johnson	10​	5​
Magic Johnson	11​	11​
Magic Johnson	12​	2​

for bigger table

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Name", "Day of the Month"}, {{"Days", each Table.RowCount(_), type number}})
in
    #"Grouped Rows"[/SIZE]

or

for smaller table

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Name"}, {{"Days", each Table.RowCount(_), type number}})
in
    #"Grouped Rows"[/SIZE]

 

[iggydarsa]

=SUMPRODUCT( --(B2:B36="Jimmy Johns"), 1/COUNTIF(C2:C36, C2:C36))

 

[sandy666]

one more possibility

Name	Count
Jimmy Johns	6​
Magic Johnson	3​

[SIZE=1]
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Day of the Month", "Name"}, {{"Count", each Table.RowCount(_), type number}}),
    #"Grouped Rows1" = Table.Group(#"Grouped Rows", {"Name"}, {{"Count", each Table.RowCount(_), type number}})
in
    #"Grouped Rows1"[/SIZE]