Hello - I have the following
formula:
=SUMPRODUCT((MONTH(Database!A2:A30)=1)*(YEAR(Database!A2:A30)=2021)*(Database!C2:C30))
Problem: In Column A and C are pretty dynamic in the sense that I will be constantly adding new row with data so the range will need to adjust accordingly.
Question: How do I update the formula above to fit my needs?
Bookmarks