Quote Originally Posted by mr.alexander View Post
how are the ranges distinguished? i.e. are there row headers for them?
Here is an example of my Worksheet

Pilot 	Customer	Flt Hours	Rate	Total
				
Tom Jones	BILL	1.55	65.00	$184.34
Tom Jones	BILL	1.78	65.00	$184.34
Tom Jones	BILL	2.01	65.00	$184.34
Tom Jones	BILL	2.24	65.00	$184.34
		             7.58		$737.36
				
Fred Wilson	FRED	7.20	20.00	$200.43
Fred Wilson	FRED	9.40	20.00	$207.63
Fred Wilson	FRED	7.60	20.00	$217.03
Fred Wilson	FRED	8.50	20.00	$224.63
Fred Wilson	FRED	5.80	20.00	$233.13
Fred Wilson	FRED	5.70	20.00	$238.93
Fred Wilson	FRED	5.30	20.00	$244.63
Fred Wilson	FRED	7.40	20.00	$249.93
Fred Wilson	FRED	5.90	20.00	$257.33
Fred Wilson	FRED	7.20	20.00	$263.23
Fred Wilson	FRED	4.60	20.00	$270.43
Fred Wilson	FRED	6.70	20.00	$275.03
Fred Wilson	FRED	4.60	20.00	$281.73
		            85.90		$3,164.09

Sorry I couldn't get it to line up properly but I think it is undestandable.

The First row does contain a header of each cell. Also as you will notice,
the first group has 4 records to sum and the second has 13.

This data is generated from our Invoice System via a Crystal Report and then Exported to Excell Data Only format. the totals that come over now are only displaying the number, not the formula.

Once the user has Exported this data from our system as shown above,
she may then have other rows to manually enter on the sheet. If she does then those values are not incorporated into the total values because they are not a formula, only the Total value that is printed by the Crystal report.

Hope all this makes sense, please let me know if you need more info....


regards

tattoo