Can you help me in debugging the following code with sumif?

[saftawy1]

I have a column B that contains the date, and a column "i" that contains incoming values, a column" j "that contains spent values, and a textbox1 contains a date and a Textbox 2 is required to show the result of collecting column cells, "i". that are smaller than the date in textbox 1, as well as collecting "j"column cells that are smaller than the date of textbox 1, then subtracting the first result from the second and showing it in textbox 2

Dim m As Double
Set ws = ThisWorkbook.Sheets("kh")
m = prosafty.TextBox1.Value
      prosafty.TextBox2.Value = WorksheetFunction.SumIf(ws.Range("b4:b100000"), "<m", ws.Range("i4:i100000")) _
      - WorksheetFunction.SumIf(ws.Range("b4:b100000"), "<m", ws.Range("j4:j10000"))

 

[duggie33]

Hi saftawy1,

I think that the criteria argument should be "<" & m rather than "<m".

I could be wrong. I tested only on a worksheet with the formula and the "m" being a cell reference.

Hope that helps,

Doug

 

[saftawy1]

Hi saftawy1,

I think that the criteria argument should be "<" & m rather than "<m".

I could be wrong. I tested only on a worksheet with the formula and the "m" being a cell reference.

Hope that helps,

Doug

i try but not work with textbox

 

[saftawy1]

i try but not work with textbox

i solved it with your help and and small modifay in the code by used cdate ty

Dim m As Double
Set ws = ThisWorkbook.Sheets("kh")
m = cdate(prosafty.TextBox1.Value)
      prosafty.TextBox2.Value = WorksheetFunction.SumIf(ws.Range("b4:b100000"), "<" & M, ws.Range("i4:i100000")) _
      - WorksheetFunction.SumIf(ws.Range("b4:b100000"), "<" & M, ws.Range("j4:j10000"))

 

[duggie33]

Can you get the SUMIF formula to work on the worksheet? Possibly use the "LinkedCell" property of the textbox and reference those in your formula/vba. I was thinking "Type mismatch" with the textbox value but you have m declared as a Double. I think textboxes are Strings usually...

 

[duggie33]

I didn't know you were working with dates. "m" declared as double, with CDATE...they can be tricky I guess. Glad you got it working.