HI,

Can I send U the sheet ? Do you think you can help me with it this way ?
Please let me know if its possible.
Regards,
M A Rehman

"galimi" wrote:

I have modified the spreadsheet to now reflect a date in column A (MM/DD/YYYY
format), a random value in Column B and alteration on the formulaic array in
column E to provide the solution I believe you are looking for.
--
http://HelpExcel.com




"M A Rehman" wrote:

HI,
In column A, I have the date mentioned in the format DD/MM/YYYY. Now against
these dates, I have certain amounts mentioned. I would like to put a formula
in place where if I select a month as the criteria, the associated total for
that month should be reflected alongside.
In similar fashion, I would need to do a count & percentage as well. Is this
possible ?


"galimi" wrote:

I have place an example at http://www.HelpExcel.com/examples

The name of the spreadsheet is db.xls
--
http://HelpExcel.com




"M A Rehman" wrote:

Hi,
I am trying to sum up a database which can be categorized under different
months. The month is mentioned in on column A & the sum is in column B.
I would like the formula to be in a diff sheet so that whenever I make
changes in the main data, the same would get updated automatically.
Can someone please help me with this.
Regards,
M A Rehman