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 |
Summing Fields with Multiple Criteria
=SUMPRODUCT(IF(TEXT(A1:A100,"Mmmm")="January",1,0) ,IF(B1:B100="John
Smith,1,0)) HTH Kostis Vezerides |
All times are GMT +1. The time now is 12:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com