Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nesting formulae with COUNTIF
At least, I believe nesting will be required.
On Worksheet 1 (titled Log) I have a Date column covering 1997 through 2005 and a Unit column with seven different units represented throughout. On Worksheet 2 (titled Synopsis) I want a formula to reflect the number of entries for Unit X in 1997. Thanks in advance! |
#2
|
|||
|
|||
Hi Helen
one option =SUMPRODUCT(--(YEAR(Log!A2:A17)=1997),--(Log!B2:B17="Unit X")) for details on how the sumproduct function works see http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards julieD "Helen McClaine" <Helen wrote in message ... At least, I believe nesting will be required. On Worksheet 1 (titled Log) I have a Date column covering 1997 through 2005 and a Unit column with seven different units represented throughout. On Worksheet 2 (titled Synopsis) I want a formula to reflect the number of entries for Unit X in 1997. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using countif function to add only a half of a number | Excel Discussion (Misc queries) | |||
OFFSET and array formulae | Excel Discussion (Misc queries) | |||
CountIF cells are not empty | Excel Discussion (Misc queries) | |||
"countif" from multiple worksheets within workbook | Excel Discussion (Misc queries) | |||
Subtotal And Countif | Excel Discussion (Misc queries) |