Thread: SUMIF help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mikeUTK mikeUTK is offline
external usenet poster
 
Posts: 1
Default SUMIF help

I am attempting to create a time card system based on information entered
onto an invoice. I have it set up so that a rate in column b is based on
which attorney is designated in column a. I placed the hours in column c and
the total charged in column d. Is there a way to sum the totals from column
d based on what is in column a? Ideally I would have ac and ao on one page,
po and pc on another page, and s on a seperate page.


a b c d
ao 185 1 185
po 135 2 270
ac 220 1.5 330
pc 190 1 190
s 50 4 200

--
Mike