Using SumProduct in Code
Hello, I use the following function to get a year to date total for a
specific month:
=SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$375=DATEVALUE("01/01")),--('Daily Reading Master
Log'!B$3:B$375<=DATEVALUE("10/31")),'Daily Reading Master Log'!AE$3:AE$375)
Question: How can i put this into a module that says if Cell B4 = October
(for example), do the above calculation and enter the value is Cell AI 7?
--
Carlee
|