WorksheetFunction.SumIfs

[Yamezz]

What am I doing wrong with the syntax here:

Qty = Application.worksheetfunction.SumIfs(OpenReport.ActiveSheet.range("D2", "D" & LastRow), _
        OpenReport.Activesheet.range("B2", "B" & LastRow), "True" _
        OpenReport.Activesheet.range("E2", "E" & LastRow), SKU _
        OpenReport.Activesheet.range("I2", "I" & LastRow), DUP)

My intention is to set the Qty variable to the sum of Column D where Column B contains the text "TRUE", Column E is the current SKU being examined and Column I is the current DUP (discounted unit price). My guess was that True was causing a problem, so I tried ""TRUE"", but that didn't help.

 

[Yamezz]

Just remove the quote marks around the "True"

I tried that first, but that doesn't work either. If it makes a difference, the code is running on a .csv file, so I'm not sure if "TRUE" (the string) is being evaluated the same as TRUE (boolean).

 

[RoryA]

FALSE wouldn't match either True or "TRUE" so I think you have a different problem.

 

[Yamezz]

FALSE wouldn't match either True or "TRUE" so I think you have a different problem.

I'm at a loss. If I use the normal SUMIFS formula, it evaluates correctly.

 

[Alex Blakenburg]

1) Can you copy paste here the "the normal SUMIFS formula" you have working ?
2) Can you show us what =ISLOGICAL(True_False_Cell_In_Here) returns ?

 

[Yamezz]

While just about to drift off to sleep last night I suddenly realised I'd made a dumb mistake! The code is actually doing what I asked it to do, but my order of operations in the rest of the code was wrong. One quick repositioning of an IF statement and I'm now getting the results I was hoping for. Sorry for the hassle!

 

[Alex Blakenburg]

Thanks for letting us know.
@RoryA was on the money yet again

FALSE wouldn't match either True or "TRUE" so I think you have a different problem.