Forum Discussion
marcrg
Oct 26, 2022Copper Contributor
Select multiple cells to perform product
Hello Help! Is there a formula/function that will enable me to find the product of all the values between two of the dates. for example, in the table below I may need it for from 2020 to 2022...
marcrg
Oct 26, 2022Copper Contributor
Apologies if there's a way to mark this as solved.
Formula here - =PRODUCT(IF((YEAR(A2:A12)>=2020)*(YEAR(A2:A12)<=2022),B2:B12))
Formula here - =PRODUCT(IF((YEAR(A2:A12)>=2020)*(YEAR(A2:A12)<=2022),B2:B12))