Excel 2007 Nested formulas

[Adam Stegeman]

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/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[T. Valko]

Try this:

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

If you're using Excel 2007:

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

 

[muddan madhu]

=COUNTIFS(F2:F5,"july",C2:C5,"C")