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.

 

[RoryA]

The syntax is fine, as long as SKU and DUP are variables that are either simple data types or single cell ranges.

 

[Yamezz]

In the first instance the SKU is VER21DOCLD and DUP is 20

 

[RoryA]

What is the actual issue?

 

[Yamezz]

This is what I get.

 

[RoryA]

Ah - you're missing a comma at the end of the line with True in it.

 

[Yamezz]

Thanks Rory. It's the simple things that trip me up!

 

[RoryA]

Me too, given I didn't spot that initially!

 

[Yamezz]

I've just realised I have a further problem with this code. The part referencing "True" as a criteria is not working. How do I write it correctly so only lines where "TRUE" occurs in column B are summed?
I hadn't realised this was an issue until I got to some data where one of the entries is FALSE and the SUMIF was mistakenly including that row's data.

 

[Alex Blakenburg]

Just remove the quote marks around the "True"