Hi,

Yes:

=SUMIF(C2:C100,"cleared",B2:B100)

HTH
Jean-Guy

"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