Thanking you in advance.
=SUMPRODUCT(N(MONTH('C:\Users\[monitor.xls]Adjusting
Output'!$A$3:$A$10001)=3),N(YEAR('C:\Users\[monitor.xls]Adjusting
Output'!$A$3:$A$10001)=2010))
Try:
=SUMPRODUCT(
(MONTH(N('C:\Users\[monitor.xls]Adjusting Output'!$A$3:$A$10001))=3)
*
(YEAR(N('C:\Users\[monitor.xls]Adjusting Output'!$A$3:$A$10001))=2010))
Alternatively:
=SUMPRODUCT(
--(MONTH(N('C:\Users\[monitor.xls]Adjusting Output'!$A$3:$A$10001))=3),
--(YEAR(N('C:\Users\[monitor.xls]Adjusting Output'!$A$3:$A$10001))=2010))
(Beware of line-wrap when you copy-and-paste into Excel.)
Note: MONTH(0) is 1 and YEAR(0) is 1900. That could give false positives
if you tested for that month and year. I doubt that will be a problem.
----- original message -----
=SUMPRODUCT(--(TEXT('C:\Users\[monitor.xls]Adjusting
Output'!$A$3:$A$10001,"mmmyyyy")="Mar2010"))
--
Biff
Microsoft Excel MVP
"gooders" <goo...@discussions.microsoft.com> wrote in message
news:E2F19503-B44A-4F74...@microsoft.com...
In the other solution I get a #value error.
Thanks guys
"T. Valko" wrote:
> .
>
Hmmm...
Try this one:
=SUMPRODUCT(--('C:\Users\[monitor.xls]Adjusting
Output'!$A$3:$A$10001>=DATE(2010,3,1)),--('C:\Users\[monitor.xls]Adjusting
Output'!$A$3:$A$10001<=DATE(2010,3,31)))
--
Biff
Microsoft Excel MVP
"gooders" <goo...@discussions.microsoft.com> wrote in message
news:453B4849-25E5-4DDF...@microsoft.com...
Lesley
"T. Valko" wrote:
> .
>
--
Biff
Microsoft Excel MVP
"gooders" <goo...@discussions.microsoft.com> wrote in message
news:280804DD-11CA-45EB...@microsoft.com...