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

When you enter an Array formula into a cell, it must be entered using
CTRL-SHIFT-ENTER instead of just ENTER. When done correctly, the formula
should be surrounded by { }.

HTH,
Elkar


"Ms. Z" wrote:

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

Thank you, thank you, thank you!!! :-)

"Elkar" wrote:

When you enter an Array formula into a cell, it must be entered using
CTRL-SHIFT-ENTER instead of just ENTER. When done correctly, the formula
should be surrounded by { }.

HTH,
Elkar


"Ms. Z" wrote:

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