| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Sum with Multiple Field Criteria
I have a spreadsheet with the following values: A B 01-JAN-06 John Smith 01-JAN-06 Jane Doe 01-FEB-06 John Smith 09-FEB-06 John Smith etc. Either in the same or new worksheet, I want to calculate the number of times "John Smith" and "JAN" appear in the same row, "Jane Doe" and "JAN", "John Smith" and "FEB", etc. The expected results would appear as follows: January John Smith 1 Jane Doe 1 February John Smith 2 Jane Doe 0 What is the formula needed to accomplish this? -- bpliskow ------------------------------------------------------------------------ bpliskow's Profile: http://www.excelforum.com/member.php...o&userid=31645 View this thread: http://www.excelforum.com/showthread...hreadid=513351 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Using Multiple Criteria | Excel Worksheet Functions | |||
| Retrieving a Value from List that meets multiple Criteria | Excel Discussion (Misc queries) | |||
| Multiple criteria LOOKUP | Excel Worksheet Functions | |||
| Multiple Criteria (add or subtract) | Excel Discussion (Misc queries) | |||
| Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
Threaded Mode
