How to get OFFSET/ COUNT to ignore formula in 'blank' cell

[jtrugger]

I'm running an office. In order to see where I've been and where I'm going I keep track of things like new patient visits, patient report visits, cash in, insurance in, etc. I keep track of this on a daily basis on one worksheet. The weekly totals are paste-linked into another sheet. It is this sheet that I would like to use to create a dynamic chart however, in using the OFFSET function to create the chart, the formula counts the 'blank' cells b/c of the paste-link from the previous worksheet. How could I get around this? Also, for some reason, the offset ignored the paste link in one column but not the one next to it. In A2 is a date that fills in (down the column) as a weeks information is entered.

---

In A2 are dates that fills in as information is entered. The offset formula for the date is: =OFFSET('Weekly Totals'!$A$2,,,COUNT('Weekly Totals'!$A$2:$A$23)) and it stops at the last date that is entered and expands as planned as new dates populate the next cell below.

---

The offset formula for the adjacent column is: =OFFSET('Weekly Totals'!$B$2,,,COUNT('Weekly Totals'!$B$2:$B$23)) however when checked, this formula selects the entire column (to B23) even when they are 'blank.'

---

Sheet: Weekly totals
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Total visits[/TD]
[/TR]
[TR]
[TD]9/7[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]9/14[/TD]
[TD]205[/TD]
[/TR]
[TR]
[TD]9/21[/TD]
[TD]143[/TD]
[/TR]
[TR]
[TD]9/28[/TD]
[TD]221[/TD]
[/TR]
[TR]
[TD]10/5[/TD]
[TD]198[/TD]
[/TR]
[TR]
[TD](='Daily Totals'!B128)[/TD]
[TD](='Daily Totals'!C128)[/TD]
[/TR]
[TR]
[TD](='Daily Totals'!B129)[/TD]
[TD](='Daily Totals'!C129)[/TD]
[/TR]
[TR]
[TD](='Daily Totals'!B130)[/TD]
[TD](='Daily Totals'!C130)[/TD]
[/TR]
[TR]
[TD](='Daily Totals'!B131)[/TD]
[TD](='Daily Totals'!C131)
[/TD]
[/TR]
</tbody>[/TABLE]


This formula works properly: =OFFSET($A$2,COUNT($A$2:$A$23)-10,,10)
This one doesnt: =OFFSET($B$2,COUNT($B$2:$B$23)-10,,10)