View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default How do I set up a spread sheet in excel

Hi

Enter the following in the cells
A2 Date
B2 Location
C2 Mileage
D2 Process
E2 Doctor

In cell C1 enter
=SUBTOTAL(9,C3:C10000)

Place cursor in cell A3 and choose WindowsFreeze Pane
This will keep you headings in place as you scroll down the screen.
Enter your data in each row from row 3 onward, and your total mileage will
appear in cell C1.

I have suggested the use of the Subtotal function, rather than Sum, in case
you want to have totals by Doctor or by location.
If so, then select cells A2:E2DataFilterAutofilter
Then when you have data entered, you can use the dropdown on the cells to
select any location or Doctor, and you will see a filtered set of results
for that choice, and the mileage will be the total for that selection.

--
Regards
Roger Govier

"Insurance Claim" <Insurance wrote in
message ...
I know nothing About spread sheets. I just need 4 columns and 1 row. The
row will be dates. columns will be location, milage , process and
doctor.
I will need to total the milage at the bottom of the spead sheet. I
understand there are different codes for entering certain data.