SUMPRODUCT HELP?

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/imag...AASUVORK5CYII=

Any help would be appreciated.
Thanks,
Jim

Code:

---

=SUMIF(D3:J3,"•",$D$2:$J$2)

---

Quote:

---

Originally Posted by Sully1440

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

---

Code:

---

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

---

Attachment 27191

Awesome. Thx Guys.
Jim