If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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... |
Thread Tools | |
Display Modes | |
|
|