Hi all:
I have this data:
A Date----------##-------Total January-----Total November
1/12009---------10---------14----------------5
11/3/2009-------5
1/4/2009--------4
-----------------3
-----------------7
Arrray enter = (month(A1:A5)=1)*(B1:b5) = 24 and not 14 since a month of a blank cell is 1 (month 1/0/1900).
Any idea how I can solve this situation using arrays.
Thanks for the help.
Victor