Countif & Sumif Question

[kimbo204]

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.

 

[Chris]

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

 

[Aladin Akyurek]

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

 

[Brian from Maui]

This message was edited by Brian from Maui on 2002-03-05 08:42