Get sum from field of values

J

jright10

I would like a formula that would get the combination of values from a field
of values that equal a given value. Example: I have a cleared amount from
bank but not which checks cleared, I know have 30 checks and the values of
the checks, which checks cleared based on the total amount.
 
B

Bob Phillips

=SUMIF(A:A,"Cleared",B:B)

eher column A holds the Cleared indicator, B the amoiunts.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top