HELP CREATING A FORMULA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a formula where I choose a specific collector, a specific aging and total the fac_bal. Any Ideas?

join fac_bal collector aging
4529514371 $3,072.00 Dave 7. >270
4547127531 $6,133.29 Dave 7. >270
4544765652 $3,120.00 Dave 7. >270
4531356182 $3,472.55 Dave 7. >270
454909755 $7,094.95 Debbie G 7. >270
451662019 $5,155.90 Debbie G 7. >270
451254395 $8,035.10 Debbie G 7. >270
454674466 $10,436.76 Debbie G 7. >270
454252578 $7,099.80 Debbie G 7. >270
454651001 $1,496.00 Janice 7. >270
450354113 $1,232.90 Janice 7. >270
453990855 $1,632.00 Janice 7. >270
 
try
=sumproduct((2:d200="Dave")*(e2:e200=??)*b2:b200)

--
Don Guillett
SalesAid Software
(e-mail address removed)
Donna said:
I need to create a formula where I choose a specific collector, a specific
Click to expand...
aging and total the fac_bal. Any Ideas?
 
That seems to work. Now I need to pick the collector and average the days they have an account. Not all of the date fields are populated.
 
Hi,

Suppose your list is in the range C6:E19. In row 2, repeat the headings in row 6. Next, in cell C4, type the following DSUM(C6:E19,1,C2:E3).

Now in cell D3 type any name from the list. Likewise, in cell E3, give any number or you may even give an argument such as >2 or <3.

Regards,

Ashish Mathur
 
Back
Top