Need some Count If help....

[SRGsMom]

I have looked and looked for a resolution, this has to be simple and I hope I'm overthinking it.

I have used sumif, countif, sumproduct, etc....nothing works.


Column C has training names in it, values could be Overview, Claims, Enrollments, etc.

Column D has a Yes or No in it (meaning did the attendee show up or not)

I want to Count the Yes responses in column D, IF the training name is Overview in column C.


So...
Overview Attended -- Want a # Here (should be 3)

Column C Column D
Trg Name Attendeed
Overview Yes
Overview Yes
Claims Yes
Enrollments Yes
Overview No
Overview Yes
Claims Yes

(I previewed the post and I see my "example" didn't work out so well, hope that isn't too confusing)

Your help would be GREATLY appreciated! I do know that on some array formulas you have to do the Control+Shift+Enter, and I'm still not getting it right.

 

[SRGsMom]

T.Valko -- I had missed that post, but yes, tried those and it just didn't work, It still gives the error message and this time is highlighting "overview". I have even tried putting the word overview in a cell and making C9:c5000=G3 and it didn't work.

I'm really beginning to think there is some setting here that is making this not work. Very puzzling. I appreciate all of everyones help!

 

[T. Valko]

T.Valko -- I had missed that post, but yes, tried those and it just didn't work, It still gives the error message and this time is highlighting "overview". I have even tried putting the word overview in a cell and making C9:c5000=G3 and it didn't work.

I'm really beginning to think there is some setting here that is making this not work. Very puzzling. I appreciate all of everyones help!

Well, at this point I'm out of suggestions.

I'd need to see the file to try to figure out what the problem is.