amend

  1. B

    Sum(Sumifs -- not returning as expected

    Can't understand where this formula is going wrong. =SUM(SUMIFS(A:A,B:B,{"bob","tim"},C:C,{"North","West"})) If I amend all entries in col C to west it returns for tim and if I amend all to North it returns for bob. I need it to return for both bob and tim irrespective if north or west.
  2. H

    Formula to find specific Text and if found return blank

    I have data on Sheet Summary =IF(Summary!C46="","",(Summary!C46)) I would like have tried to amend the formula so that if A46 contains "Sales Month End*" , then the result must be blank, otherwise return the result C46 =IF(Summary!A46="Sales Month End*","",C46) The formula above...
  3. G

    Save Me from My TEXTBOX hell!!!

    Hi, pretty new to VBS so heeeellllppppp!!! me, please.. I have created a listbox on a page that displays the contents of another workbook. The contents of which are added via another userform titled “AddNew” I have created a duplicate userform call “Amend”. What I’d like to be able to is to...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top