SUM function multiple another cell

New Contributor

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

@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.

 

 

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

@Techy25 

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