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

=SUMPRODUCT(--(A6:A12=B1),--(A6:A12<=B2),--(B6:B12=B3),C6:C12)


"swimfast" wrote:

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