LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Michelle Tucker
 
Posts: n/a
Default I'm always coming up against this!

I always seem to have this problem, and any solutions I have I don't truly
understand!
I have a list of products sold in one column, and in the next, the name of
the salesperson who sold it.
What I want to do is count up the amount of particular products sold by each
person.
I understand countif and sumif, but it seems to be done with a combintation
of INDEX and MATCH, which I don't get.
What is the easiest way to do this as it is something I always seem to need
to do, but then chicken out!
--
Michelle Tucker
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find which column or row the Min() value is coming from Luanne Excel Discussion (Misc queries) 4 April 29th 05 08:32 PM
can anyone help with times not coming across correctly in pivot t. [email protected] Excel Worksheet Functions 0 March 9th 05 01:47 AM
can anyone help with times not coming across correctly in pivot t. [email protected] Excel Worksheet Functions 0 March 9th 05 01:45 AM
why are nested subtotals coming out below outer subtotals? Hendy Excel Worksheet Functions 2 January 18th 05 08:09 PM
Coming up with #N/A Rj Excel Worksheet Functions 4 December 28th 04 07:03 PM


All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"