I have columns set up. Some have names and some have numbers.

Can I use sumproduct to do the following?

Column A is State Text
Column B is Date Month
Column C is Mode Number
Column D is Name Text

Can I use sumproduct to select state, date, mode, and then count the
occurances of a specific name in column D?

Count, not sum? Is that possible?