WorksheetFunction SumIfs With Multiple Criteria

Hi,

I am using the below formula within a macro to calculate the sum of everything with the code "120012". This formula works absolutely fine.

I'm trying to get the below to calculate the total when the criteria is "120010" + "820600". However i am unsure how to edit the below formula


Sheets("Journal").Range("K2").Value = WorksheetFunction.SumIf(Sheets("Journal").Range("C:C"), "=120010", _
Sheets("Journal").Range("D:D"))



Any help is much appreciated

Harry

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...-criteria.html

Thread Closed.