Trying to figure our what this formula means and error(s)

[Jack-P-Winner]

Can anyone tell me what these are saying? Plus I am getting errors. It has a little yellow like triangle. Could this be as simple as my parenthesis do not match on each side and I need to add 1 more after =SUMPRODUCT?

=SUMPRODUCT(--MID(CH11,ROW(INDIRECT("1:"&LEN(CH11))),1))

=COUNTIF($BK$2:$BK$51,BK18)-COUNTIF($BK$2:$BK17,BK18)

=ABS(LEFT(AE13,1)-IF(RIGHT(AE13,1)="0",10,RIGHT(AE13,1)))


=(COUNTIF(F11:F60,AB13)+COUNTIF(Q11:Q60,AB13)+COUNTIF(AB11:AB60,AB13)+COUNTIF(AM11:AM60,AB13)+COUNTIF(BQ11:BQ60,AB13)+COUNTIF(BR11:BR60,AB13)-(COUNTIF(F11:F12,AB13)+COUNTIF(Q11:Q12,AB13)+COUNTIF(AB11:AB12,AB13)+COUNTIF(AM11:AM12,AB13)+COUNTIF(BQ11:BQ12,AB13)+COUNTIF(BR11:BR12,AB13)))

 

[Jack-P-Winner]

Where this error is all it says is =F11 in that cell so I do not get it

 

[Jack-P-Winner]

https://www.dropbox.com/s/ndhchsoriupxwhy/Error Symbol.PNG

 

[SirJB7]

Hi, Jack-P-Winner!
I seriously doubt that it'd be of any help, but you asked, you get it. Give a look at the uploaded file with the formulas explanation.
Regards!

 

[Jack-P-Winner]

Thank you Sir , you are always of help!!!

 

[Debraj]

https://www.dropbox.com/s/ndhchsoriupxwhy/Error Symbol.PNG

 

[Jack-P-Winner]

Debra,

Are you trying to tell me something?