Lookup and sum formula? Not sure?

[richarddec]

I am trying to use 2 sheets.

summarysheet <-------displays total cost for all rows that are part
of 20 seperate job #'s

datasheet <-------place to enter (in order) all bills
received

The colums of the datasheet are:

job# Date Description Reference
Gst Pst



Now i want to be able to add as many rows and job numbers as possible
to the datasheet, but have all entries of job 600 to sum and display on
the summary sheet. There are usually 20 ongoing jobs to count and have
sums for. ANy ideas how I can do this?

 

[Roger Govier]

Hi Richard

This is an ideal problem for a Pivot Table. The Pivot report would replace
your sheet 2.
Take a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
and
http://www.contextures.com/xlPivot07.html
for good information on how to use Pivot Tables