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
use
=SUMPRODUCT((--($F$3:$AE$3="Yes")+--($F$3:$AE$3="No")),$F$2:$AE$2)
or
=SUMPRODUCT(($F$3:$AE$3={"Yes";"No"})*$F$2:$AE$2)
Last edited by Azam Ali; 09-19-2011 at 03:23 AM.
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
You can use SUMIF()
=SUM(SUMIF(F3:AE3,{"Yes";"No"}),F2:AE2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks