G
Guest
Hello -
I want to add one column based on bgn/end date parameters, and account.
I've tried using a combination of SUMIF and OFFSET without success. Assume
the following data:
*Data will be in chronological order.
*It's possible records will not exist for the first or last day of the month.
A B C
1 Begin Dt 01/01/07
2 End Dt 01/31/07
3 Acct. 1
4
5 Date Acct Amt
6 01/02/07 001 $100.00
7 01/03/07 001 $2.00
8 01/04/07 002 $75.00
9 02/06/07 001 $20.00
10 02/28/07 001 $42.00
11 03/01/07 004 $11.00
12 03/02/07 003 $22.00
From this data, I would expect the formula to return $102.00.
I know this is easy in SQL, but is it possible using formulas?
Any thoughts on this would be greatly appreciated!!
Sincerely,
Patrick
I want to add one column based on bgn/end date parameters, and account.
I've tried using a combination of SUMIF and OFFSET without success. Assume
the following data:
*Data will be in chronological order.
*It's possible records will not exist for the first or last day of the month.
A B C
1 Begin Dt 01/01/07
2 End Dt 01/31/07
3 Acct. 1
4
5 Date Acct Amt
6 01/02/07 001 $100.00
7 01/03/07 001 $2.00
8 01/04/07 002 $75.00
9 02/06/07 001 $20.00
10 02/28/07 001 $42.00
11 03/01/07 004 $11.00
12 03/02/07 003 $22.00
From this data, I would expect the formula to return $102.00.
I know this is easy in SQL, but is it possible using formulas?
Any thoughts on this would be greatly appreciated!!
Sincerely,
Patrick