Summing in Excel (%)

[yenrod]

Is it possible to sum a row of %'s - to display in percentage form

 

[HelenD123]

Yes. Just tried it and it worked fine. Make sure what you're doing makes mathematical sense though.

 

[yenrod]

Yes. Just tried it and it worked fine. Make sure what you're doing makes mathematical sense though.

Well - come on Girl - explain yourself forthwith !!!

 

[Keith Oates]

Just put the figures in a line down the page with the % sign after each number. At the bottom of the column press the Summation sign and it adds up giving the number with a % sign after it.

 

[HelenD123]

What Keith said. Or I usually type =SUM( then highlight the cells then ). If the values are % your result will display as %.

 

[yenrod]

Yeah, got it, thanks for the help !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[bonj2]

Just type in '100%' as a literal, they'll never bother to check.

 

[yenrod]

- yeah, the area manager likes that....

It was at 99.9% anyhow...

Just for the record I done it like this =sum(a1:a15)/31