PDA

View Full Version : [SOLVED:] SUMPRODUCT HELP?



Sully1440
09-25-2020, 08:25 AM
Hey All,
I'm having trouble with an excel formula.
I'm attempting to sum percentages only if there is a symbol ("•") in the row. I'm guessing its a sumproduct but I can't figure out the formula. See attached.

http://www.vbaexpress.com/forum/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgEAAAApCAYAAACshvoTAAAGTUlEQVR4nO2dvW4i PRSGfTdUFGgbcgHcAAVbUKEoN0CXiIILQJGQaKItU0coShOlTpeaVej3IlJEOlswPx6PGfb7MuP j4MeStckAjh9z7Pf1z wYEZHPP7 TzfDDr10H OGHX4//4 0h2SwiYggC LXrAD/88MOvxa8txJiACIJAuw7www8//PDr8GsLMSYggiDQrgP88MMPP/w6/NpCnIAJuJMrY8QYI8YM5Pa1fO1pml83cnXvXp/I0zftBO/LQcFVZX6W2x/Ges2I XEt74rtAT/8bZf5 ee3fN5PMha33nGNB/B3Of7HF 8 /pCi zgumS/X7vWRPJ6fCbAD3lQ7xf2k Pl9OSiD4/VaLpyg6DoIWi0zq7 XualTKLUH/PC3W6bLaA/m8Y0H8CuZgIjG/2Ciux4VQr b98T0Z7J7e5CP7UyGjik4HxOQu HsC86d39W988UXAZEFjeUWQwRBq2W XsvV8tnpBLnjP86n1R7ww99umVmdp5NM8CwRjHA8gD ACYgo3n38oQS3IvyFIdjIqm/K6 dmAvJl0YtsUKz87nOC95PaElmIIOi8ExRM2Uxgeld/r1J7wA9/N2Xf1UQwxvEA/gArwRHFu49fdSVgPRJjerLahjcAQUyA7XTLL74MinJPaCC3rw0B03EQdFa 4/x9y4H1vbCw7QE//N2UXRfBGMcD MNuB2vHu48/pOiWZwJ6stou5NIYMeOFigGIwgTY eCKJ/JkB06AZaGu MvDYbazbdgTVGoP OHvgv//iCD858Rvt0E88e7j1xLg3byXrQxkZsCE3xYIZgK8y1/2e7PDIBfL58NnpndFAHV9QKQL/tLhNp1wLQ/N1BgDtgf88LfNf8jHRTCm8QD ULcIxhHvPn4VE5AdBhzON4fVgfFCPjIzEPKAYOcm4Nhyl/vFPk1z13cIlEOnsH/uNghaLTM/HX7Sxbr7xTrtAT/8rfIXuS6CMY4H8Ic2Abrx7uPXMAGP43zWfzgYOJxv5KPy87mYgH9ZDnJuCfnuKwHVe8SdvTDf7W OuWARuD/jhb7O8MntEMMLxAP4Ox/8I493Hr7UKkM/4z3sloBYIrgv0HAax3x/gkIiqCNRmi HbA3742y6zwmL8IhfLeAB/QBMQQbz7 MOaAM9hwMwUGPf62ZiAyDP88GvXAX744dfjD74SEFHGBNAJ4IdfvQ7ww6/Jry3EmIAIgkC7DvDDDz/88OvwawsxJiCCINCuA/zwww8//Dr82kKMCYggCLTrAD/88MMPvw6/thBHYQJIJBKJRCKll8x v5eUs4io1wF OGHH34dfrM03qw9Sw 2EqD9JWhnOgH82nWAH3749fhTNQCYADoB/PDDD796HbT5UzUAmAA6Afzwww /eh20 VM1AJgAOgH88MMPv3odtPlTNQCYADoB/PDDD796HbT5UzUAmAA6Afzwww /eh20 U L5UIu zPZvT3Ibt6rPP3P 8S/9aj2IKDySYFOuaYnq63n7528nj2IqJLt10byiAmgE8APP/zww9/Mf9IEbGcyzAT8cWyJs0fsveZgO5NhfySXfVeYv2oCfO/5Ribg5aZ85Org5iW5TgA//Cnzx5Lhh79R/D2PBTfGyHC OSK29Wu7eU G803xLyZgv5f9r59Oow7k5iWhTgA//CnzR5Thh/ UUBazf2tFwJ71V4R9PXKEfiOrvvX5bFsheRNgz4K0Z0ManQB FPmjynDD3 zUG5klS/j1wQ 2xIohN0S/MpWwLHX2z4TkAt/eYYhWhOQ/EwIfvhT5o8oww//8RUA/1aAqcyym2b6D7UtgOrvXa0EbGQ1jt0E7NkThR/ lPljyfDD3yiUxezfWhFwcvOef5OJOCbkG1n1PXcebGcyPPnZ/5ZVTUAsmU4Av3Yd4Icffj3 JpEsbwlsWGIvTv87olzZKvAJ/HEh3817zoqDe5vhqTMB/2YQMAF0AvjhV68D/PBr8n9lJm0Lu //BqidIcgFfrzwrhTY769tR1TK968ynDIXmAA6Afzwww8//Bb/103A982YADoB/PCr1wF DX5tYUYExBBEGjXAX744Ycffh1 bSHGBEQQBNp1gB9 OGHX4dfW4gxAREEgXYd4Icffvjh1 HXFmJ1EyAkEolEIpGSTH8BUj3hwsfg/5YAAAAASUVORK5CYII=

Any help would be appreciated.
Thanks,
Jim

p45cal
09-25-2020, 08:57 AM
=SUMIF(D3:J3,"•",$D$2:$J$2)

Paul_Hossler
09-25-2020, 09:07 AM
I'm attempting to sum percentages only if there is a symbol ("•") in the row. I'm guessing its a sumproduct but I can't figure out the formula



=SUMIF($D$3:J3,CHAR(149),$D$2:J2)


27191

Sully1440
09-25-2020, 09:55 AM
Awesome. Thx Guys.
Jim