Hey folks,
So I'm attempting to use an array function in VBA. Well, attempting- As an example, here's what I'd enter into a cell:
=SUM((A2:A25="North")*(C2:C25>VALUE("7-Apr-2005"))*(E2:E25="2-Door"))+SUM((A2:A25="North")*(C2:C25>VALUE("7-Apr-2005"))*(E2:E25="4-Door"))
Followed by cntrl-shift-enter.
That'd count all instances of North, After April-7-2005, with 2-Door OR 4-Door. Great.
But to get that in VBA....
Range("D30") = Application.WorksheetFunction.Sum(???)
Any ideas?
Bookmarks