=SUMPRODUCT(--(B2:B100),--(C2:C100="Cleared"))

Dave
--
Brevity is the soul of wit.


"Alex" wrote:

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