Excel 2007 Nested formulas
 

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

Excel 2007 Nested formulas
 

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

Excel 2007 Nested formulas
 

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


On Oct 21, 1:08*am, Adam Stegeman wrote:
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 Patternhttp://www.eggheadcafe.com/tutorials/aspnet/ec832ac7-6e4c-4ea8-81ab-7...