Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting from different tables
Hi
I have 3 columns 1 with week number, 1 with rep code i.e. 101 102 103 104 and one with values How do I count the number of values that pertain to a specific rep and week number and also how do i return the value that relates to the rep code and week number Week Number Value Rep Code 1 £3,200 103 1 £1,000 106 1 £450 104 1 £1,000 106 1 £1,000 102 1 £800 106 1 £500 106 2 £2,000 102 2 £2,200 104 2 £1,230 104 2 £1,000 102 I am trying to insert these values in to a sales tracker by week by number and value automatically and am having trouble |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting from different tables
see response to your later posting
-- Regards Roger Govier "Garf" wrote in message ... Hi I have 3 columns 1 with week number, 1 with rep code i.e. 101 102 103 104 and one with values How do I count the number of values that pertain to a specific rep and week number and also how do i return the value that relates to the rep code and week number Week Number Value Rep Code 1 £3,200 103 1 £1,000 106 1 £450 104 1 £1,000 106 1 £1,000 102 1 £800 106 1 £500 106 2 £2,000 102 2 £2,200 104 2 £1,230 104 2 £1,000 102 I am trying to insert these values in to a sales tracker by week by number and value automatically and am having trouble |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Pivot Tables--Counting Blank Cells | Excel Worksheet Functions | |||
formula in pivot tables involving counting text cells | Excel Worksheet Functions | |||
Double Counting in Pivot Tables | Excel Discussion (Misc queries) |