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