List:General Discussion« Previous MessageNext Message »
From:mos Date:January 12 2011 6:09pm
Subject:Re: Function Question
View as plain text  
Have you tried:

select  UserName, Sum(ColB) from Table group by UserName;

or

select  UserName, Sum(ColB) from Table group by UserName where 
UserName="Emily";

Mike


At 11:43 AM 1/12/2011, Nicholas Moreno wrote:
>My issue is actually in Excel. I'm hoping someone could help me...
>
>I need to total the values in column B for "Emily". Is there a way other
>than =SUM (B1+B2+B4+B7)?
>--------------
>Emily | 1
>-------------
>Emily | 5
>-------------
>Greg | 2
>-------------
>Bob   | 7
>-------------
>Emily | 4
>-------------
>Jenn | 2
>-------------
>Greg | 1
>-------------
>Emily | 7
>-------------
>Bob  | 3
>-------------
>Emily | 3
>-------------
>
>
>Nick Moreno|Communications Project Specialist|Home Federal Savings Bank
>
>1016 Civic Center Drive NW|Rochester MN, 55901|Work 651-405-2010|Cell
>612-987-0584
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Which row in which table has been accessed at which time?mysql12 Jan
  • Re: Which row in which table has been accessed at which time?Martijn Tonies12 Jan
  • Re: Which row in which table has been accessed at which time?MySQL)12 Jan
  • Function QuestionNicholas Moreno12 Jan
    • Re: Function Questionmos12 Jan