Is there any way to get the value from a cell that has a formula in it to be used in another formula?
https://docs.google.com/spreadsheets/d/1jkRAY0REiVHh7jN00Qtsa_OKiGObhHXYRF-qMxyk-r8/edit?usp=sharing
If you check cell D1, it has 0 in it I assume because it cannot get the value from the if() function in the formula for the range.
Thank you!
CodePudding user response：
try:
=SUMPRODUCT(B1:B50)
or:
=INDEX(SUM(B1:B50*1))
or change your IF to:
=IF(A1 < TODAY(), 2500, 0)
tho B1 should be:
=INDEX(IF(A1:A="",,IF(A1:A < TODAY(), 2500, 0)))