Formula to assist with Counting Dates

[Dilly]

Is it possible to utilise the formula below , however, by just highlighting
the whole column as the range, as opposed to physically highlighting from
A1:A1000. If i use this folrmula and highlight column A as opposed to
A1:A1000 i get a NUM error

=SUMPRODUCT(--(MONTH(A1:A100)=2),--(YEAR(A1:A100)=2009))

 

[edvwvw via OfficeKB.com]

SUMPRODUCT does not work with columns, at least not Excel 2003 - you have to
define the range

edvwvw

 

[Francis]

SUMPRODUCT works with a defined range, such as A2:A100.
It don't works when you use the whole column.
All the range in the formula must be of the same size.

In 2007, you can use SUMIFS with whole column
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another