Forum Discussion
SUM function multiple another cell
I have a cell with this formulae "=SUM(Ledger!H22:H62)", is it possible to use this cell and multiple with another cell? Because I would like to convert the currency, so i need to multiple that value.
Thank you!
3 Replies
If you want to do this in the formula itself:
=SUM(Ledger!H22:H62)*$M$2
where M2 is the cell with the conversion factor.
If you want the result in another cell:
=B2*$M$2
where B2 is the cell with the formula and M2 is the cell with the conversion factor.
- Hi thanks for getting back! But I got error for this. I think because the formulae in the cells use "#" e.g D6#*E6#
It depends on does you Excel version support dynamic arrays (Excel 365 and Excel 2021) or not.
