View Full Version : SumIf Function


aandress
03-12-2002, 12:43 PM
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
03-12-2002, 01:35 PM
Sum(Iif([Managed] = Yes,[AccumulatedValue],0))

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

aandress
03-12-2002, 01:59 PM
Thank you SO much. Worked perfectly!