| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tallying a total dependant on contents of another cell
we have three salesman, each with their name listed down column "V".
we also have a column for retail$ which lists the total value of an order (each order has it's own separate row). How do I setup a running tally in another worksheet to look in column "V" and detect who's name is there and then have it automatically tally the retail$ from that row under that person's name ? Could it be a job for conditional formatting or an if then statement ? Thanks in advance :) -- my signature |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tallying a total dependant on contents of another cell
hey again guys,
I solved my problem with the sumif function. cheers !! -- my signature "Toby" wrote: we have three salesman, each with their name listed down column "V". we also have a column for retail$ which lists the total value of an order (each order has it's own separate row). How do I setup a running tally in another worksheet to look in column "V" and detect who's name is there and then have it automatically tally the retail$ from that row under that person's name ? Could it be a job for conditional formatting or an if then statement ? Thanks in advance :) -- my signature |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
| How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) | |||
| substract cell F from cell H and total into cell I | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
