If you replace 1 with Row(A1) you can drag it down to change months
VBA Noob=sumproduct(--(Month(rangewithdates)=Row(A1)),rangewith$)
If you replace 1 with Row(A1) you can drag it down to change months
VBA Noob=sumproduct(--(Month(rangewithdates)=Row(A1)),rangewith$)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks