Thanks:  0
Likes:  0

# Thread: Countif & Sumif Question

1. I have a spreadsheet that contains a list of loans closed by date along with other relevant information relating to each loan. I want to count the number of loans closed and also sum the total dollars closed each month. I'm not sure where to begin.

2. Here is one way to do it
Say you have 3 columns, Dollar Amount(ColA), Status (Closed or Open)(ColB), and a third column for your total closed (ColC)

In column C, enter an if formula and copy it to each row

=if(B1="Closed",A1,"")

this will return the Dollar amount if that loan is closed, or a blank cell if the loan is open.

Then just sum up Column C with a sum function.

Hope that helps

3. On 2002-03-04 07:36, kimbo204 wrote:
I have a spreadsheet that contains a list of loans closed by date along with other relevant information relating to each loan. I want to count the number of loans closed and also sum the total dollars closed each month. I'm not sure where to begin.
Have a look at PivotTables.

For a formula-based approach, see the example discussed at:

http://www.mrexcel.com/wwwboard/messages/8961.html

4. [ This Message was edited by: Brian from Maui on 2002-03-05 08:42 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•