Prev: Excel 2007 - A Conditional Formatting ?'s
Next: Need a quanity of items printed
From: Roy Gudgeon on 30 Mar 2010 10:34
I have a sales database with >300 records (sales orders) allocated to 6
salespersons. The database is added to constantly.

I want to be able to run a report at any given time for each person showing
their total sales to date.

Any ideas ?
--
thanks
Roy
From: Luke M on 30 Mar 2010 10:47
Either use the COUNTIF function, or a PivotTable would also be very useful.

--
Best Regards,

Luke M
"Roy Gudgeon" <RoyGudgeon(a)discussions.microsoft.com> wrote in message
news:EC7A9FAB-C633-41B9-B1C6-26CCBA3BA557(a)microsoft.com...
>I have a sales database with >300 records (sales orders) allocated to 6
> salespersons. The database is added to constantly.
>
> I want to be able to run a report at any given time for each person
> showing
> their total sales to date.
>
> Any ideas ?
> --
> thanks
> Roy


From: Michael_R on 30 Mar 2010 10:56
Assuming you have the salesperson's names in column A and the orders in
column B you could do the following:

Make a list of all salesperson's names - say starting in D1
The formula in E1 for the first person's orders then is: =SUMIF(A:A,D1,B:B);
copy down.

I anticipate that your next question will be how to limit the totals to a
specific period; but that's another story.

"Roy Gudgeon" wrote:

> I have a sales database with >300 records (sales orders) allocated to 6
> salespersons. The database is added to constantly.
>
> I want to be able to run a report at any given time for each person showing
> their total sales to date.
>
> Any ideas ?
> --
> thanks
> Roy
From: Roy Gudgeon on 30 Mar 2010 11:49
hi Luke

thanks for reply, the sumif function suggested by michael sloved my problem.
I did try to use Pivot tables but got some strange results (problably me!)
--
thanks
Roy


"Luke M" wrote:

> Either use the COUNTIF function, or a PivotTable would also be very useful.
>
> --
> Best Regards,
>
> Luke M
> "Roy Gudgeon" <RoyGudgeon(a)discussions.microsoft.com> wrote in message
> news:EC7A9FAB-C633-41B9-B1C6-26CCBA3BA557(a)microsoft.com...
> >I have a sales database with >300 records (sales orders) allocated to 6
> > salespersons. The database is added to constantly.
> >
> > I want to be able to run a report at any given time for each person
> > showing
> > their total sales to date.
> >
> > Any ideas ?
> > --
> > thanks
> > Roy
>
>
> .
>
 | 
Pages: 1
Prev: Excel 2007 - A Conditional Formatting ?'s
Next: Need a quanity of items printed