Count if formula

[Lorna B]

Hi

I have attached a workbook for reference.

I want the bar chart to show the count of each year and i have input a formula which i believe to be correct but its not working?

Can anyone help me with what im doing wrong?

Thanks

Lorna

[Lorna B]

Forgot to attach

here you go.

Thanks

[martindwilson]

=COUNTIF(A2:A176,"Strongly Agree") text needs to be in quotes

[Lorna B]

Thanks for this!!