Sum columns only if certain value is present

[Alex]

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

 

[VBANoob]

Hi,

Try

=SUMPRODUCT(--($C$2:$C$100="Cleared")*($B$2:$B$100))

VBA Noob