The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community
Geekfinder
UFie Gear
Advertise on UF
Forum Rules
& FAQ

Username

Password


Create a New Account

  
 

Back to UserFriendly Strip Comments Index
Excel question by Jito4632007-05-09 08:45:24
  You don't need the SUM function by fiordhraoi 2007-05-09 08:53:19
SUM adds up a number of cells that you reference. For example, =SUM(A1,B2,X99) would give you the sum of those three cells. =SUM(A4:A8) would give you the total of cells A4-A8.

You should just be able to do this as =(B1/A1)*100

[ Reply ]
    Common misconception there, by jeff_uk2007-05-09 09:18:02
      Misuse of average? What do you.... *cough*...mean? (n/t) by poolya2007-05-09 09:20:10
    Aye - that's a pet peeve of mine. by poolya2007-05-09 09:18:15
      for reference, SUMPRODUCT is useful too :) (n/t) by jeff_uk2007-05-09 10:24:55

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)