| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SPECIFIC WORD COUNT FROM A RANGE
Hi,
I need to count and separate the number of specific clients into lists with their relative costs only. how can i acheive this? Example: ( say client list is B4:B1000. Project details C4:C1000 & Cost is D4:D1000) Client1 project details £1000 client2 project details £3500 client1 project details £ 500 client1 project details £2000 client2 project details £1500 client3 project details £4000 my list would be: 3 Client1 £3500 2 Client2 £5000 1 Client3 £4000 any help greatly appreciated. thanks, Nigel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
| How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
| Vlookup of parts of a word in a range of Data | Excel Discussion (Misc queries) | |||
Threaded Mode
