conditional summing formula problems

  • Thread starter Thread starter christopherp
  • Start date Start date
C

christopherp

Hi Guys,

Below are cells from my spreadsheet.

Richard 30-Jul-04 $92,000.00
Richard 30-Jul-04 $434,000.00
Richard 23-Jul-04 $10,000.00
Rod 23-Jun-04 $360,500.00
Rod 20-Jul-04 $75,000.00
Rod 3-Aug-04 $208,000.00
Dennis 29-Jul-04 $226,500.00
Michelle 26-Jul-04 $128,000.00
Richard 25-Jun-04 $160,000.00
Dennis 22-Jun-04 $135,000.00
Richard 15-Jul-04 $230,000.00
Dennis 04-Jun-04 $110,000.00
Rod 16-Jul-04 $48,000.00
Greg 27-Mar-04 $100,000.00

What I would like to do is work out the value of all loans written b
each loan writer in a given date range.

This formula will be run on a seperate worksheet to the one containin
the data

To make it easier as the months go by I plan to enter the start an
finish date for the date range in two cells i.e. (>a2<a3)

where a2 contains 01/07/04 and a3 contains 31/07/04

so far I have come up with:


=IF(Refinances!E4:E50="rod",IF(Refinances!F4:F50>Stats!
F2<Stats!F3,""))

I know this is not even close but hey i am trying.

I will being running this formula in a seperate cell for each loa
writer so in the formula above I will change "rod" to each loan writer
name

Where I am running into trouble is summing only the amounts in th
third column which correspond to the appropriate loan writer

I hope it is clear what I would like to do, I just know someone ou
there could do this with their eyes closed (are you out there Fran
from Germany?)

Thanks a bunch

Chris :confused
 
Now if I only had read below >a2 and <a3
nevertheless this is something the autofilter is better at


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top