#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Where this error is all it says is =F11 in that cell so I do not get it
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using multiple formulas in one (IF, AND and SUM) gives syntax error | markdeniet | Word | 1 | 02-05-2014 05:17 AM |
Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
At wit's end trying understand styles for numbering/bullet levels in MS Word | gopher_everett | Word | 3 | 02-22-2013 05:19 PM |
Symbols I don't understand appearing in word | suzantn | Word | 2 | 11-22-2012 08:36 AM |
IF Formulas | mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |