SUM Function

[Guest]

In a Excel spreadsheet, is the SUM function only for adding numbers or can it be properly used to create formulas, i.e.
=SUM(I23*H23)

 

[Peo Sjoblom]

Sure, but it isn't necessary
in your example at least

=SUM(I23*H23) = I23*H23

It can be used to count with

=SUM(--(A2:A10>5))

entered with ctrl + shift & enter will count values greater than 5,
it is however slower than COUNTIF(A2:A10,">5") and you can
use SUMPRODUCT in most cases without having to array enter the formula

--

Regards,

Peo Sjoblom

In a Excel spreadsheet, is the SUM function only for adding numbers or can

it be properly used to create formulas, i.e.