Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MMM MMM is offline
external usenet poster
 
Posts: 14
Default formula

I am working with a word pad document that I imported into excel. I need a
formula that will total the inspectors money that was collected. There are
numerous stations and the rows will vary every day. One day there might only
be 50 rows, the next day may be 65 rows of data. I have copied part of the
spreadsheet for an example of what I am dealing with. I need a total amount
for 4122, 4124 and 4302.

STATION/INSPECTOR/AMOUNT /This is the formula i need to give me these amounts
---- ------ ------------
P-01 4122 1,188.25 1188.25
P-01 4124 869.75 869.75
---- ------ ------------
P-02 4302 9.5 95.25
P-02 4302 85.75 (blank)