How To Find SUM of Parts of a Colum that relate to the info in the column beside...

[missdoji]

I am using Excel 2008 for Mac. I have a spreadsheet that I am essentially using as a simple cheque ledger so that I can keep track of who I have written cheques to, for what amount, and what has already cleared.

I have a the following columns:

Name
Date Written
Cheque Amount
Cleared?

In the 'Cleared?' column I mark an X when it has cleared the bank. I'm trying to find a way to get the SUM of the whole 'Cheque Amount' column that hasn't cleared (ie: has nothing in the 'cleared' column). Any suggestions??? I'm new to Excel & stumped...

Thanks a million.

[Cheeky Charlie]

=sumif(<range with 'x's and blanks>,"",<range to sum>)

HTH

[missdoji]

Genius!

Thank you so much....

[Cheeky Charlie]

Thanks, please mark the thread as solved.

CC