Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SumIf Help?? | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |