VBA SUMIFS with OR criteria

[Akbarov]

Hello community,

I need help to add 1 more criteria for following SUMIFS but can't figure out how to do that. And there is no any similar question on the internet.
Criteria I want to add:
if wks.Range("K:K"), {"Cash Reload","Cash","Reload"}

                            Profit = WorksheetFunction.SumIfs(wks.Range("K:K"), wks.Range("C:C"), ws.Cells(x, 9 + i).Value, _
                            wks.Range("F:F"), ">=" & firstDate, _
                            wks.Range("F:F"), "<=" & secondDate)

Hope someone can help me to figure out.
Thanks

 

[DanteAmor]

if wks.Range("K:K"), {"Cash Reload","Cash","Reload"}

But column K, according to the code, is the range of values.
In which column do you have this data:"Cash Reload","Cash","Reload"?

Could you put a sample of your data and what is the result you expect.

 

[Akbarov]

Hello Dante thanks for the reply. But I want to add that criteria to my SUMIFS
So, it will sum either if K:K contains either :"Cash Reload" or "Cash" or "Reload"

 

[DanteAmor]

Profit = WorksheetFunction.SumIfs(wks.Range("K:K")

In that line of the macro, column K contains the values to add.

Could you put a sample of your data and what is the result you expect.

Please could you

 

[Akbarov]

I am sorry Dante, that was mistake, it is actually L:L which contains: "Cash Reload" or "Cash" or "Reload"

 

[Akbarov]

Found solution, if someone will need:

                                Profit = Application.Sum(Application.SumIfs(wks.Range("K:K") _
                                , wks.Range("C:C"), ws.Cells(x, 9 + i).Value, _
                                wks.Range("F:F"), ">=" & firstDate, _
                                wks.Range("F:F"), "<=" & secondDate, _
                                wks.Range("L:L"), Array("Cash Reload", "Cash")))