Count # of times "text" is in 1 column is specific date is in the other column

		Microsoft Office Forums > Microsoft Excel > Excel
Count # of times "text" is in 1 column is specific date is in the other column

12-31-2016, 07:41 AM

NoSparks

Windows 7 64bit Count # of times "text" is in 1 column is specific date is in the other column

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Try this inTabulation sheet B2

Code:

=SUMPRODUCT((Table4[Campus]="NB")*(MONTH(Table4[Oritentation Start Date])=1))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N	mikey386	Excel	2	12-11-2014 01:14 PM
Set tables in email to default to "AutoFit Column Width"?	viper92283	Outlook	0	02-26-2014 03:31 PM
Can you turn off the "autofit column widths on update" by default?	New Daddy	Excel	0	11-23-2013 09:56 PM
Custom column in "List" view, show on Contact Card	phillyhy	Outlook	0	05-16-2012 11:13 PM
"First column" in word table page break border	mj1856	Word Tables	1	04-25-2012 03:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 PM.