Basically...
I'm trying to figure out how to do something in Excel that could readily
be done in MS Access.

I have an Excel list, and I want to know how many records contain
"Chicago" in one of the fields.

I thought up this array formula:

=SUM(IF(F2:F1123="chicago",1,0))

The idea is that, for every cell containing "chicago," Excel would enter
a "1" in a duplicate range and a "0" if the cell didn't contain
"chicago." Excel then would add up the ones and tell me how many
records in the list were from...Chicago.

This doesn't appear to work after I do [control][enter]. I get a "0."
What am I doing wrong? Is my syntax incorrect? Am I even on the right
track?

Any leads are much appreciated.