Using SUMIFS and COUNT Together?

[Dukefrukem]

Is it possible to use these two functions together?

What I WANT to do is this:

=SUMIFS(COUNT(J7:J165),Name,$L7,Month,M$5)

But that syntax is obviously incorrect.

So, I'd like for the SUMIFs to use the first sum range, to simply count the number of rows I am adding together.

Example: My data is 100 rows, My Criteria_Name1 would be Name. So I'd like this formula to count how many times Name appears over that 100 rows.

Should be simple enough.

Thanks in advance for help

 

[Aladin Akyurek]

What is the expected result?