if then statement

[Guest]

i need to find out if i can do this, its kind of like a check register where
i can take

check number amount cleared
111 20 *
112 40 *
113 50
114 60 *

what ever has not cleard and tells me what the total amount is of the checks
not cleared.

 

[Dave Peterson]

You can use =sumif().

=SUMIF(C2:C5,"~*",B2:B5)

Since =sumif() can work with wild cards (like * and ?), the tilde-asterisk (~*)
tells excel that the formula is looking for an asterisk in C2:C5 (not any old
set of characters).