| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting by Two Columns of Variables
I have three worksheets: call data, staff, and VIPs. The staff and VIP
worksheets each contain only a single column of names. The call data sheet contains a list of staff names and caller names along with call data. I need to count the number of calls (records) in which the staff name matches one of those on the staff sheet AND the caller name matches one of those on the VIP sheet. I've tried playing around with COUNT and MATCH to no avail. How would I perform such a count? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Days with variables | Excel Worksheet Functions | |||
| counting the number of two different variables | Excel Discussion (Misc queries) | |||
| Counting values for variables in separate columns | Excel Discussion (Misc queries) | |||
| Counting multiple variables returns #VALUE | Excel Discussion (Misc queries) | |||
| counting based ona number of variables. | Excel Worksheet Functions | |||
Threaded Mode
