Thank You DonkeyOte, using your suggestion i have managed to get rid of the div/0 mind you it is replaced with 0.00 at least it calculates now

The only weird thing is i had to modify the formula slightly, didn't need to CSE.

Here is a copy of what i modified. (all i need to do is now is ref the date to a cell as u suggested)

=AVERAGEIF($B$3:$B$380,"3/12/2008",IF(ISNUMBER($D$3:$D$380),$D$3:$D$380,0))

I have 2 tables set up with the headings on columns as below

Table1
Date, Time, Systolic, Diastolic, Pulse

Table2 (Daily Averages)
Date, Systolic, Diastolic, Pulse

Final cell in this table
Total Averages

The reason for the second table is merely to graph as i don't want to clutter a graph with times bp is taken just a daily average.

Each month is in a separate worksheet, and a final worksheet with a overall summary of YTD.

If anyone has any suggestions how i can simplify this project i am all ears!

Thanks again!!