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