VBA Sumif Function

[TaskMaster]

Hi all,

I have been trying to integrate some formulas into my VBA but struggling with the following sumif. In the data tab I have a list of dates in column T and the sum range is CB. I am wanting the total of the sumif in C2 of the movements tab where the date is before the current day. Thank you in advance

Sheets("Movements").Range("C2") = WorksheetFunction.SumIf(Range('Data'!T:T), Range("<Format(Date, "dd/mm/yyyy")"), Range('Data'!CB:CB))

 

[Cubist]

Not sure if you want a formula or value but try:

Value:

Sheets("Movements").Range("C2").Value = WorksheetFunction.SumIf(Sheets("Data").Range("T:T"), Format(Date, "dd/mm/yyyy"), Sheets("Data").Range("CB:CB"))

Formula:

Sheets("Movements").Range("C2").Formula = "=SUMIF('Data'!T:T, TEXT(TODAY(), ""dd/mm/yyyy""), 'Data'!CB:CB)"

 

[TaskMaster]

Not sure if you want a formula or value but try:

Value:

Sheets("Movements").Range("C2").Value = WorksheetFunction.SumIf(Sheets("Data").Range("T:T"), Format(Date, "dd/mm/yyyy"), Sheets("Data").Range("CB:CB"))

Formula:

Sheets("Movements").Range("C2").Formula = "=SUMIF('Data'!T:T, TEXT(TODAY(), ""dd/mm/yyyy""), 'Data'!CB:CB)"

This works perfectly, is it possible to alter so it picks up days less than the current day?

 

[Cubist]

This works perfectly, is it possible to alter so it picks up days less than the current day?

Which option? Value or formula?

 

[TaskMaster]

Which option? Value or formula?

I managed to work it out, but thank you for your assistance with this