# rewrite

1. ### Conditiona Index/Match Statement Help

Hello: I have the following formula =INDEX(CCMSTime!C:C,MATCH(A2,CCMSTime!A:A,0)) Works great, except when there is nothing to return I get the following #N/A, which causes problems when I am trying to do SUM How can I rewrite my formula so that if there is nothing to return Excel places a 0...
2. ### Combining Sumifs Help Please

Hi Is their a way to rewrite these 2 sumifs (array) into 1 so that I would have 4 conditions? =SUM(IF((\$H\$2:\$H\$2634<\$N3)*(\$H\$2:\$H\$2634>=N4),\$G\$2:\$G\$2634,"")) =SUM(IF((\$A\$2:\$A\$2634<\$O3)*(\$A\$2:\$A\$2634>=O4),\$G\$2:\$G\$2634,"")) Thank you! MM
3. ### Help with vba code placement please

I have this code in my “Thusworkbook” Sub COPY() Sheets("Legend").Range("R4").COPY Sheets("Bid Calculator").Range("C29") With Sheets("Bid Calculator") For MY_COUNT = 3 To 7 If Not (IsEmpty(.Cells(29, MY_COUNT).Value)) Then A =...
4. ### Rewrite formula

Hi all, I was given the following formula by one of you guys on here (Thanks so much) It works apart from the fact I would like it to look down the two columns and match the specific text then do the remainder of the formula rather than be assigned specifically to each row ('PMI Schedule...
5. ### How can Excel rewrite a copied cell value based on my instructions?

Hi I am currently copying information from a different source into Excel. The source gives me values which i want to rewrite. An example would be that the source gives me a value in column M that is "1". But i need to rewrite that information into "Completed". This is now done manually but i...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back