|
|
|
|
#1
04-22-2014, 03:12 PM
|
|||
|
|||
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
04-22-2014, 03:50 PM
|
|||
|
|||
|
Where this error is all it says is =F11 in that cell so I do not get it
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 8 
Office 2010 64bit
Hybrid Mode