Linking in and calculations

Hi All,

I have had some trouble and would greatly appreciate any help.
I will try and dot point this.
Any Cell numbers begining/finishing in " " relate to the entry with " "

Below is Table one with the information required. On Page Name: Results



Date Sampled "G12" "I12" "J12" "K12" "L12"
Water Type HPC FStrep TTColi EColi

4/05/2011 "Chlorine" "N/A" "N/A" "N/A" "N/A"
1/02/1915 Micro 15,000.00 <1 1.00 1.00
1/01/2011 Micro <1 1.00 <1 <1



Below is the Data I need to creat my required graphs on Page Name: Result Graph (Micro)

"A40" "B40" "C40" "D40" (ETC)
Samples HPC NON Exceedance HPC Exceedance (ETC)
"January" " " " " " "
Febuary -- -- -- --
March -- -- -- --


1.All Micro results for January on Page: "Results" are to be added as a individual sample and placed in Cell B40 on Page: "Result Graph"
2. On Page: "Results" - All January only HPC NON Exceedance are to added as a individual sample and placed in Cell C40 on Page "Result Graph"

Examples. If 2 samples were HPC exceedances in Febuary on "Results" Page then Cell D41 would display a result of 2.

Example 2. If 3 samples were HPC NON exceedances in January on "Results" Page then Cell C41 would display a result of 3.

Example 3. 15 Micro samples were taken in March some exceedances some not. Page "Result Graph" Cell B42 will display 15. (All samples taken for the month)

Note: all results for each month on the year will be displayed together on the same Page (Results)



This may be hard. It is something i need to achieve even if it requires restructuring my pages all together.


I am very appreciative for any help!

Cheers.

Have you tried using Pivot tables and pivot graphs for this.

this would allow you to complete the 'results' page with any information you wish. then you can group by month and it will display a selection of the information you wish to look at.

Try this link for more help if you are not familiar with pivot tables.

http://www.timeatlas.com/5_minute_ti..._organize_data