Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How can i change this formula
=(COUNT.IF(R!$D$4;"=*01) to this =(COUNT.IF(R!$D$4;"=*02) I try find and replace but with no result. The real formula is: Count is contar and se is if in portuguese =(CONTAR.SE(R!$D$4;"=*01*"))+(CONTAR.SE(R!$F$4;"=* 01*"))+(CONTAR.SE(R!$H$4;"=*01*"))+(CONTAR.SE(R!$J $4;"=*01*"))+(CONTAR.SE(R!$L$4;"=*01*"))+(CONTAR.S E(R!$N$4;"=*01*"))+(CONTAR.SE(R!$P$4;"=*01*"))+(CO NTAR.SE(R!$R$4;"=*01*"))+(CONTAR.SE(R!$T$4;"=*01*" ))+(CONTAR.SE(R!$V$4;"=*01*"))+(CONTAR.SE(R!$X$4;" =*01*"))+(CONTAR.SE(R!$Z$4;"=*01*"))+(CONTAR.SE(R! $AB$4;"=*01*"))+(CONTAR.SE(R!$AD$4;"=*01*"))+(CONT AR.SE(R!$AF$4;"=*01*"))+(CONTAR.SE(R!$AH$4;"=*01*" ))+(CONTAR.SE(R!$AJ$4;"=*01*"))+(CONTAR.SE(R!$AL$4 ;"=*01*"))+(CONTAR.SE(R!$AN$4;"=*01*"))+(CONTAR.SE (R!$AP$4;"=*01*"))+(CONTAR.SE(R!$AR$4;"=*01*"))+(C ONTAR.SE(R!$AT$4;"=*01*"))+(CONTAR.SE(R!$AV$4;"=*0 1*"))+(CONTAR.SE(R!$AX$4;"=*01*"))+(CONTAR.SE(R!$A Z$4;"=*01*"))+(CONTAR.SE(R!$BB$4;"=*01*"))+(CONTAR .SE(R!$BD$4;"=*01*"))+(CONTAR.SE(R!$BF$4;"=*01*")) +(CONTAR.SE(R!$BH$4;"=*01*"))+(CONTAR.SE(R!$BJ$4;" =*01*"))+(CONTAR.SE(R!$BL$4;"=*01*")) Best regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index Function/Match Function | Excel Discussion (Misc queries) | |||
formula help to change row colour automatically by some conditions | Excel Worksheet Functions | |||
Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
IF/AND Formula seems to only be reading 1st part of formula | Excel Worksheet Functions | |||
Cannot change a formula | Excel Discussion (Misc queries) |