View Single Post
 
Old 04-22-2014, 03:12 PM
Jack-P-Winner Jack-P-Winner is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Nov 2013
Posts: 3
Jack-P-Winner is on a distinguished road
Default Trying to understand formulas and error

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)+COUN TIF(AB11:AB60,AB13)+COUNTIF(AM11:AM60,AB13)+COUNTI F(BQ11:BQ60,AB13)+COUNTIF(BR11:BR60,AB13)-(COUNTIF(F11:F12,AB13)+COUNTIF(Q11:Q12,AB13)+COUNT IF(AB11:AB12,AB13)+COUNTIF(AM11:AM12,AB13)+COUNTIF (BQ11:BQ12,AB13)+COUNTIF(BR11:BR12,AB13)))

https://www.dropbox.com/s/ndhchsoriu...r%20Symbol.PNG
Reply With Quote