RE: tallying a total dependant on contents of another cell

Giganews Newsgroups
Subject: RE: tallying a total dependant on contents of another cell
Posted by:  Toby
Date: Mon, 29 May 2006

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

Replies

None

In response to

tallying a total dependant on contents of another cell posted by Toby on Mon, 29 May 2006