MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sumif function in VBA

Posted by windall bekker on August 15, 2001 4:02 PM


I am trying to craete an addif function in VBA where the user can specify a from and to date and VBA adds the sales that occurred beween those dates.

I tried using the application.worksheetfunction.sumif function but with no success. Can anyone please help me ?

Posted by Russell Hauf on August 15, 2001 4:25 PM

Can you provide an example?

Does it have to be in VBA? Also, can you provide an example of how your data looks?

Thank you,