D
Dan the Man
The Design
I have the array formula below which is designed to capture all data entries
between a specific time period (2007), look only at entires entitled "CIC
(column c reference), and further look only at those 2007 CIC entires that
show an "improvement" score (scores greater than 0). The improvement scores
are identified in column k.
The Formula
=SUMPRODUCT(--('Q 3 + 7'!A4:A500>=DATE(2007,1,1)),--('Q 3 +
7'!A4:A500<=DATE(2007,12,31)),--('Q 3 + 7'!C4:C500="CIC"),--('Q 3 +
7'!K4:K500>0))
The Problem
I keep getting an outcome from this formula of "0", and I know that isn't
accurate. On my sheet entitled "Q3+7" I have 112 clients who show improvement
on column K, so I know that "0" isn't the accurate answer. That means I've
made a formula error I suspect.
Thanks in advance for any suggestions. I'm sure it is a minor "tweak", but I
just can't figure it out....Dan
I have the array formula below which is designed to capture all data entries
between a specific time period (2007), look only at entires entitled "CIC
(column c reference), and further look only at those 2007 CIC entires that
show an "improvement" score (scores greater than 0). The improvement scores
are identified in column k.
The Formula
=SUMPRODUCT(--('Q 3 + 7'!A4:A500>=DATE(2007,1,1)),--('Q 3 +
7'!A4:A500<=DATE(2007,12,31)),--('Q 3 + 7'!C4:C500="CIC"),--('Q 3 +
7'!K4:K500>0))
The Problem
I keep getting an outcome from this formula of "0", and I know that isn't
accurate. On my sheet entitled "Q3+7" I have 112 clients who show improvement
on column K, so I know that "0" isn't the accurate answer. That means I've
made a formula error I suspect.
Thanks in advance for any suggestions. I'm sure it is a minor "tweak", but I
just can't figure it out....Dan