Knowledge Base Articles By Category
Recent Forum Posts
=SUM(((A2:A19="SP")+(A2:A19="DP"))*(((""(D2:D19))+(""(E2:E19))+(""(F2:F19)))>0)*(B2:B19="X"))
Welcome to the forum. 
Attach a sample workbook, please. Your formula does not inherently pull a top five list, nor does it sum anything,...
Calculate a total (countifs)
A guess:
=SUM((('CE PCOE PTSA'!M1:M19="SP")+('CE PCOE PTSA'!M1:M19="DP"))*("X"=('CE PCOE PTSA'!AN1:AN19))*(("X"='CE