LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Change part of formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Index Function/Match Function M Moore Excel Discussion (Misc queries) 3 September 3rd 06 11:49 AM
formula help to change row colour automatically by some conditions Aarif Excel Worksheet Functions 6 March 17th 06 03:51 PM
Change formula for Employee Shift Schedule template Pam Soreide Excel Worksheet Functions 1 September 7th 05 03:10 AM
IF/AND Formula seems to only be reading 1st part of formula Greg Bobak Excel Worksheet Functions 2 March 3rd 05 01:53 AM
Cannot change a formula Richard F Excel Discussion (Misc queries) 1 January 18th 05 01:57 AM


All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"