Microsoft Office Forums - View Single Post - [Solved] Count # of times "text" is in 1 column is specific date is in the other column

Thread: [Solved] Count # of times "text" is in 1 column is specific date is in the other column

View Single Post

Old

12-31-2016, 07:41 AM

NoSparks

NoSparks is offline

NoSparks uses Windows 7 64bit

Windows 7 64bit NoSparks uses Office 2010 64bit

NoSparks uses Office 2010 64bit

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 831

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

Default

Try this inTabulation sheet B2

Code:

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

Reply With Quote