Lookup and sum formula? Not sure?

  • Thread starter Thread starter richarddec
  • Start date Start date
R

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?
 
Back
Top