SUM function multiple another cell

[Techy25]

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!

[#2]

@Techy25 

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.

[#3]

Hi thanks for getting back! But I got error for this. I think because the formulae in the cells use "#" e.g D6#*E6#

[#4]

@Techy25 

It depends on does you Excel version support dynamic arrays (Excel 365 and Excel 2021) or not.