| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Fields with Multiple 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=513340 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing Fields with Multiple Criteria
=SUMPRODUCT(IF(TEXT(A1:A100,"Mmmm")="January",1,0) ,IF(B1:B100="John
Smith,1,0)) HTH Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Rows with Multiple Criteria | Excel Worksheet Functions | |||
| Counting by multiple criteria | Excel Worksheet Functions | |||
| Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
| Summing with multiple criteria | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Linear Mode
