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=mo...@fastmail.fm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org