Hello,

I am a novice with excel and I am trying to get a formula to work with array and criteria.

The formula I am using is:
=SUM(COUNTIFS('Kevin Accounts'!$B$2:$B$560,">="&'Formula Data'!A2,'Kevin Accounts'!$B$2:$B$560,"<="&'Formula Data'!A6,'Kevin Accounts'!$C$2:$C$560,{"Live with Support","100% complete},'Kevin Accounts'!$I$2:$I$560,,{"HT RED","HT Halifax","Legacy Diversity","HT AURORA 1 OR 2","DATA ENTRY ROCH","HT Roch","WELLS/BANK","NYS","STORE KIT","GOVERNMENT/FED"},'Kevin Accounts'!$J$2:$J$560,{"Implementation","Restructure"))

This is a long formula and I am not sure of any other way to do it. I will also need a second formula to count a specific dollar amount that falls with in this criteria as well.

Any help would be greatly appreciated. Thank you.