- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Formula help!!!

Subject: | Formula help!!! |

Posted by: | Jer (such_a_do…@hotmail.com) |

Date: | Tue, 14 Oct 2003 |

I am currently trying to figure out a short cut to

calculate a series of numbers for a class. Here is the

scenario:

I have 12 numbers in twelve cells (B2:B13). I need to

square each individual number then sum the total of all of

those numbers.

I have tried different formulas for SUM reference but no

go. I discovered that there is a function, POWER, that I

can use but it is not working out despite what others have

told me to do. Please help me with the formula anyone.

I have Excel 97 if that makes a difference.

Thanks,

Jer

- Re: Formula help!!! posted by Ken Wright on Tue, 14 Oct 2003
- Re: Formula help!!! posted by Ron Rosenfeld on Wed, 15 Oct 2003