title: Excel COUNTIFS equivalent in SQL Server
body: <p>This may seem silly, but what is the countifs equivalent in sql server? I have 2 columns, and want to count where both repeat. So if column 1 is date and there are 2 dates of 1/1/2016 and column 2 is name and there are 2 names of Bill, how would I show this as a 3rd column called count, which would produce the number 2 as the result?</p>