SumIf Function

[aandress]

Is it possible to use a SumIf Function in a controlsource in a form?

If so... what is wrong with this code:

=SUMIF("AccumulatedValue","'Managed' = Yes")

I want to add the values in the accumulated value field if the Yes/No box is clicked yes.

Or... any other way to get the value of just the accumulated value cells that are managed (managed field = yes).

Thank you!

 

[Rich]

Sum(Iif([Managed] = Yes,[AccumulatedValue],0))

[This message has been edited by Rich (edited 03-12-2002).]

 

[aandress]

Thank you SO much. Worked perfectly!