i 0got a spreadsheet (data) as below
got a report sheet where the summary is listed as below
count for the year - (year)
month approved suspended rejected
based on the year the user types in the (year cell)...e.g. 2009 the months should be generated below the month column and below each status e.g. approved it should get the total count of approved status for the month of january 2009 from the data sheet and count for suspended for the month of jan . likewise count for all months according to their status.
i cud do the above by a macro...but like to use functiions if possible for this.
PS actually many sites have been blocked by our organization so you or anyone else know some nice site to upload file please do let me know .... I've tried almost 50 sites and only this was not blocked .......