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 Windows>Freeze 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:E2>Data>Filter>Autofilter
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 Claim DeleteThis @discussions.microsoft.com> wrote in
message news:35294363-DE85-4C2A-99BF-E66A742E1348@microsoft.com...
> 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.