Try this:

=SUMPRODUCT(--(E1:E10="C"),--(F1:F10="July"))

If you're using Excel 2007:

=COUNTIFS(E1:E10,"C",F1:F10,"July")

--
Biff
Microsoft Excel MVP


<Adam Stegeman wrote in message ...
In cell AD4 I want a number to appear. I want it to count how many times
the letter "C" appears in column E IF column F has the word "July" in
the corresponding row. How do I set up this nested formula?

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx