First post on any forum, ever. Please cut me some slack if this message isn't pretty.
My SUM function is too big and excel doesn't like it.
I have a table of integers with sales reps as column headings and sold products as rows...
In each row (B through N) the highest non-zero value(s -if a tie) are highlighted. //yay for that sales rep
What I am trying to achieve is a count of each highlighted cell from row5 to row67 and present that value in the 68th row of that column without using helper cells.
Can someone help me to find a more elegant function to display the number of times an individual sales rep has been a winner?

=SUM(IF(AND($B$5>0,$B$5=MAX($B$5:$N$5)),1,0),IF(AND($B$6>0,$B$6=MAX($B$6:$N$6)),1,0),IF(AND($B$7>0,$B$7=MAX($B$7:$N$7)),1,0),IF(AND($B$8>0,$B$8=MAX($B$8:$N$8)),1,0),IF(AND($B$9>0,$B$9=MAX($B$9:$N$9)),1,0),IF(AND($B$10>0,$B$10=MAX($B$10:$N$10)),1,0),IF(AND($B$11>0,$B$11=MAX($B$11:$N$11)),1,0),IF(AND($B$12>0,$B$12=MAX($B$12:$N$12)),1,0),IF(AND($B$13>0,$B$13=MAX($B$13:$N$13)),1,0),IF(AND($B$14>0,$B$14=MAX($B$14:$N$14)),1,0),IF(AND($B$15>0,$B$15=MAX($B$15:$N$15)),1,0),IF(AND($B$16>0,$B$16=MAX($B$16:$N$16)),1,0),IF(AND($B$17>0,$B$17=MAX($B$17:$N$17)),1,0),IF(AND($B$18>0,$B$18=MAX($B$18:$N$18)),1,0),IF(AND($B$19>0,$B$19=MAX($B$19:$N$19)),1,0),IF(AND($B$20>0,$B$20=MAX($B$20:$N$20)),1,0),IF(AND($B$21>0,$B$21=MAX($B$21:$N$21)),1,0),IF(AND($B$22>0,$B$22=MAX($B$22:$N$22)),1,0),IF(AND($B$23>0,$B$23=MAX($B$23:$N$23)),1,0),IF(AND($B$24>0,$B$24=MAX($B$24:$N$24)),1,0),IF(AND($B$25>0,$B$25=MAX($B$25:$N$25)),1,0))+SUM(IF(AND($B$26>0,$B$26=MAX($B$26:$N$26)),1,0),IF(AND($B$27>0,$B$27=MAX($B$27:$N$27)),1,0),IF(AND($B$28>0,$B$28=MAX($B$28:$N$28)),1,0),IF(AND($B$29>0,$B$29=MAX($B$29:$N$29)),1,0),IF(AND($B$30>0,$B$30=MAX($B$30:$N$30)),1,0),IF(AND($B$31>0,$B$31=MAX($B$31:$N$31)),1,0),IF(AND($B$32>0,$B$32=MAX($B$32:$N$32)),1,0),IF(AND($B$33>0,$B$33=MAX($B$33:$N$33)),1,0),IF(AND($B$34>0,$B$34=MAX($B$34:$N$34)),1,0),IF(AND($B$35>0,$B$35=MAX($B$30:$N$35)),1,0),IF(AND($B$36>0,$B$36=MAX($B$36:$N$36)),1,0),IF(AND($B$37>0,$B$37=MAX($B$37:$N$37)),1,0),IF(AND($B$38>0,$B$38=MAX($B$38:$N$38)),1,0),IF(AND($B$39>0,$B$39=MAX($B$39:$N$39)),1,0),IF(AND($B$40>0,$B$40=MAX($B$40:$N$40)),1,0),IF(AND($B$41>0,$B$41=MAX($B$41:$N$41)),1,0),IF(AND($B$42>0,$B$42=MAX($B$42:$N$42)),1,0),IF(AND($B$43>0,$B$43=MAX($B$43:$N$43)),1,0),IF(AND($B$44>0,$B$44=MAX($B$44:$N$44)),1,0),IF(AND($B$45>0,$B$45=MAX($B$45:$N$45)),1,0),IF(AND($B$46>0,$B$46=MAX($B$46:$N$46)),1,0))+SUM(IF(AND($B$47>0,$B$47=MAX($B$47:$N$47)),1,0),IF(AND($B$48>0,$B$48=MAX($B$48:$N$48)),1,0),IF(AND($B$49>0,$B$49=MAX($B$49:$N$49)),1,0),IF(AND($B$50>0,$B$50=MAX($B$50:$N$50)),1,0),IF(AND($B$51>0,$B$51=MAX($B$51:$N$51)),1,0),IF(AND($B$52>0,$B$52=MAX($B$52:$N$52)),1,0),IF(AND($B$53>0,$B$53=MAX($B$53:$N$53)),1,0),IF(AND($B$54>0,$B$54=MAX($B$54:$N$54)),1,0),IF(AND($B$55>0,$B$55=MAX($B$55:$N$55)),1,0),IF(AND($B$56>0,$B$56=MAX($B$56:$N$56)),1,0),IF(AND($B$58>0,$B$58=MAX($B$58:$N$58)),1,0),IF(AND($B$59>0,$B$59=MAX($B$59:$N$59)),1,0),IF(AND($B$60>0,$B$60=MAX($B$60:$N$60)),1,0),IF(AND($B$61>0,$B$61=MAX($B$61:$N$61)),1,0),IF(AND($B$62>0,$B$62=MAX($B$62:$N$62)),1,0),IF(AND($B$63>0,$B$63=MAX($B$63:$N$63)),1,0),IF(AND($B$64>0,$B$64=MAX($B$64:$N$64)),1,0),IF(AND($B$65>0,$B$65=MAX($B$65:$N$65)),1,0),IF(AND($B$66>0,$B$66=MAX($B$66:$N$66)),1,0),IF(AND($B$66>0,$B$66=MAX($B$66:$N$66)),1,0))
excel.jpg