Too many to update: Code for CTRL+SHIFT+ENTER

I have a ton of cells that contain formulas with arrays. How can I update these without:

clicking the cell
clicking the formula bar
then hitting CTRL+SHIFT+ENTER

There's got to be a faster way of doing this. And I'm fairly new to this level of using Excel so please forgive me if it's an obvious answer.

I get #value instead of the proper data from the worksheet. I know you have to use CTRL+SHIFT+ENTER to "activate" the array. But I have so many to do that I need a short cut. Here is the formula:

=SUM(--('1'!$B$14:$B$500=2)*--('1'!$H$14:$H$500="C")*--('1'!$K$14:$K$500="P"),--('1'!$B$14:$B$500=2)*--('1'!$H$14:$H$500="I")*--('1'!$K$14:$K$500="P"),--('1'!$B$14:$B$500=2)*--('1'!$H$14:$H$500="S")*--('1'!$K$14:$K$500="P"))


I'm using this in almost every cell on a tracking worksheet for a workbook that contains multiple worksheets.

Forced recalculation does not work. I would like to upload the worksheets, but I would not have a job after that. I'll see if I can fabricate an example that encompasses all the variables in my formula. In the meantime if you can think of anything else, please post it.

Thank You!