sumif from another worksheet excel vba

[curious K]

I've worksheet "summary" & "ExpLedgers"

ExpLedgers having 8 columns

The 8th no. column i.e. column H having Ledgers GroupCode
I want sum of 6th column (Column F) to store in variable


DataArr(R1, 1) --> Group code store in this array e.g. here it is 16

for this I use following function but it gives an Run-time error '13' Type mismatch

WorksheetFunction.SumIf(Sheets("ExpLedgers").Range("$F:$F"), Sheets("ExpLedgers").Range("$H:$H"), DataArr(R1, 1))

 

[XOR LX]

Hi.

The syntaxes for SUMIF and SUMIFS are annoyingly inconsistent.

With SUMIF, it's:

=SUMIF(range, criteria, [sum_range])

Looks like you might have these in the wrong order.

Regards

 

[curious K]

Yes after change accordingly it works!

WorksheetFunction.SumIf(Sheets("ExpLedgers").Range("$H:$H"), DataArr(R1, 1), Sheets("ExpLedgers").Range("$F:$F"))

Thanks.

 

[XOR LX]

You're welcome!

Cheers