Hi everyone,

Is it possible to sum a list of values, but only count the value if a
particular field in the row equals something? So for example, I have
column B having a value and column C can have either Pending or
Cleared. I want to sum all values from say B2 through B100 where C2
through B100 equals Cleared. Is this possible?

Thanks ..

Alex