Need two formulas. #1-counts all "2002" transactions (A:A) that are aged "0-30"(B:B). #2-sum total dollar values (C:C) of all transaction from formula #1.
FY Full Age Amount
2002 0-30 $100.00
2002 0-30 35.00
2001 61-90 25.00
2001 0-30 354.00
2000 >365 125.00
For 2002 transactions aged 0-30, results should be :
2002=2
Age sum= $135.00
FY Full Age Amount
2002 0-30 $100.00
2002 0-30 35.00
2001 61-90 25.00
2001 0-30 354.00
2000 >365 125.00
For 2002 transactions aged 0-30, results should be :
2002=2
Age sum= $135.00