Not quite sure how to start this, but i'll give it a go anyway!
I'm (and you are too!) still helping to streamline a charity's spreadsheet.
There are two worksheets that this question refers to: "DD Tally" and "List of DD Donors" (where DD stands for Direct Debit).
In the DD Tally worksheet we are trying to summarise the information contained within the List of DD Donors.
We would like to be able to estimate how much, in direct debit donation, we will recieve in the financial year (currently, April 06 to March 07). We would like this to be seperated into our monthly, quarterly, semi-annual and annual donors.
The challenge is knowing how to search through a column to find the, for example, "Monthly" entries and once these have been found to find the quantity of the donation(s) in the rows with "Monthly" in them, and then, to determine the number of months they have been paying for during the financial year (their first payment dates are listed as 01/MM/YY) - i.e, the difference between the end of the financial year (03/07) and the start (04/06) or between the time they joined during the financial year and the end. Then to multiply the number of months the direct debit has been active during the year by the amount they donate.
A long winded challenge to explain - please ask if anything is unclear!!
Any help here would be highly appreciated by all of us at the Fundraising Deptartment