Identifying a selection of a selection of a range

S

swimfast

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Subtotals 3
Which functions and Procedure to use to have desired result? 0
Auto Change Notification 4
Check if a date comes before/after a range of dates 0
Calculated fields 2
Matching related records from a single table 2
Dynamic Named Range: Simulating a filtered region 0
Dynamic Named Range: Simulating a filtered region 1

Top