CountIF for Year?

GoGophers22

Creating the summary report and trying to count if column has year in it - for example, 2015. Trying the formula: =COUNTIF(YEAR, [Record Initiation Date]:[Record Initiation Date] =2015) with no luck. Thoughts?

bcwilson.ca

I think you are trying to do too much at once

One I just used yesterday was to put an extra column called "Year" in my main file that was

=YEAR(Date@row)

Then I did

=COUNTIF([Year Column]:[Year Column], =2015)

Especially if it is a summary report you will be linking to another sheet

=COUNTIF({Data File Year}, =2015)

bcwilson.ca

I think you are trying to do too much at once

One I just used yesterday was to put an extra column called "Year" in my main file that was

=YEAR(Date@row)

Then I did

=COUNTIF([Year Column]:[Year Column], =2015)

Especially if it is a summary report you will be linking to another sheet

=COUNTIF({Data File Year}, =2015)

GoGophers22

Yup, I had something similar to that before. I was just hoping that I didn't have to create another column in the sheet itself, but that makes sense. I can always hide the year column from people.

Thank you!