Has any one ever experienced this... I am writing a function in the function
builder and I get the correct answer, however when i press OK, the cell comes
up with 0 in my worksheet. Basically, I am trying to sum numbers in an array
where my flag is 0 and the month is the one i enter in another cell. I
cannot understand why it is working in the expression builder perfectly, but
not in the worksheet?!

=SUM(IF(Incomes!$P$2:$P$5000=0,IF(MONTH(Incomes!$A $2:$A$5000)=MONTH($D$17),Incomes!$L$2:$L$5000,0),0 ))