Nesting formulae with COUNTIF

[Guest]

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!

 

[JulieD]

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