I have the following formula, and have a continuation to it, for which i am getting an error saying "Fomula is too long". Can I use a sumproduct formula along with countif, i have 26 columns to which i have to apply this formula.

($F$2)*COUNTIF(F3, "Yes")+($F$2)*COUNTIF(F3, "No")+($G$2)*COUNTIF(G3, "Yes")+($G$2)*COUNTIF(G3, "No")+($H$2)*COUNTIF(H3, "Yes")+($H$2)*COUNTIF(H3, "No")+($I$2)*COUNTIF(I3, "Yes")+($I$2)*COUNTIF(I3, "No").... and goes on.

Please help me