One way:

=SUMPRODUCT(--(C1:C10="John Doe"),--(D1:D10="G"))

In article ,
rjenkins wrote:

Can Someone help out with this? I am trying to use the Sum formula to
count multiple criteria. I want to COUNT how many times that "John
Doe" with a Grade of "B" appear in the list.