Hi,
Try
=SUMPRODUCT(--(MONTH(B18:B80)=1)*(B18:B80<>"")*(J18:J80<>"Paid Acc.")*(J18:J80<>"refund"))
Where 1 equals Jan.
VBA Noob
Hi,
Try
=SUMPRODUCT(--(MONTH(B18:B80)=1)*(B18:B80<>"")*(J18:J80<>"Paid Acc.")*(J18:J80<>"refund"))
Where 1 equals Jan.
VBA Noob
Last edited by VBA Noob; 03-25-2007 at 11:30 AM.
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks