Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 balks at 7 nested IFs | Excel Worksheet Functions | |||
Nested IF compatability error with Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 nested function | Excel Worksheet Functions | |||
Excel 2007 Nested Sumif's | Excel Worksheet Functions | |||
nested formulas in excel | Excel Discussion (Misc queries) |