I'd use one of these techniques from Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

Then I'd add headers and use data|subtotals to get the subtotals.

(or maybe add headers and use a pivottable)


pgarcia wrote:

Row A has the following:
East
East
East
<-blank cell
East
East
<-blank cell
South
South
<-blank cell
South
<-blank cell
West
West
West
West
<-blank cell
West
<-blank cell
<-blank cell
West
West

I would like to copy "East" all the way down to the last East in the Row,
then inset a cell and type "East Total" and do the same for South and West.
The data changes from day to day. Can this be done? Here is the end result:
East
East
East
East<-was a blank cell
East
East
East<-was a blank cell
East Total
South
South
South<-was a blank cell
South
South<-was a blank cell
South
West
West
West
West
West<-was a blank cell
West
West<-was a blank cell
West<-was a blank cell
West
West
West Total

--

Dave Peterson