Formula to assist with Counting Dates
 

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))

Formula to assist with Counting Dates
 

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

edvwvw

Dilly wrote:
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))

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1

Formula to assist with Counting Dates
 

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



"Dilly" wrote:

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))