Date Count
On Thu, 19 Jun 2008 04:15:02 -0700, Richard
wrote:
Mike
Thanks for the reply. I found the issue was that I had entered
=sumproduct(--(year(a:a)=year(today()))) with there being a lable (column
header) in cell a2. I kept getting a return of #NUM!
Is there a way around the label issue.
Richard
I'm surprised you are getting a #NUM! error and not a #VALUE! error.
Since you have specified an entire column as your argument, I am assuming you
are using Excel 2007. That being the case, you can try this **array** formula:
=SUM(--(IF(ISNUMBER(--A:A),YEAR(A:A))=YEAR(TODAY())))
To enter an array formula, hold down <ctrl<shift while hitting <enter. Excel
will place braces {...} around the formula.
If you are not using Excel 2007, then your arguments must not encompass an
entire column. e.g:
=SUM(--(IF(ISNUMBER(--A1:A65535),YEAR(A1:A65535))=YEAR(TODAY())))
--ron
|