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
