vba sumifs

  1. O

    Vba code for a sumif formula - place a new sheet

    Thanks in advance for your assistance, and I will let you know if this works. Objective: To Sumif Column J based on Column A from Sheet 1 into Sheet 2, where not only are Columns J and A transferred, but the remaining columns are also. Given: -Sheet1: --N rows x 10 Columns (Columns A...
  2. C

    sumifs, $

    Hi I am having trouble with my sumifs in vba. It is returning error 1004. I think that it is due to one the word that it is referencing as it has the symbol $ after the word Overtime. I have tried the following: 1. putting in " - however that didn't work as it then reads the characters and...
  3. S

    to define a custmized function to add values in cells seperted by comma

    Hello</SPAN> I always get daily data in following format with last 2 characters </SPAN>fixed for quantity.</SPAN> Column A Column B</SPAN> New York Apple_20, Orange_15,Pineapple_05 London Orange_22,Pineapple_20 Paris Pineapple_07 Tokyo </SPAN> New York Apple_20 London...
  4. S

    Sumifs vba

    Hi I am trying to do a SUMIFS in VBA. The below code works just perfect if I hardcode the arguments - Sub Ageingformulas2() Dim Customer As Range Dim Bucket As Range Dim Amount_GBP As Range Set Customer = Sheets("K135512002").Range("G:G") Set Bucket = Sheets("K135512002").Range("K:K")...

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