Looks like I might have answered my own question, makes sense should have tried it first. select sum(field) from table where field1='val'; On 2/3/06, Dan McCullough <dan.mccullough at gmail.com> wrote: > is there away in mysql to add up a certain row in a query? > > For instance I want to get all dollars from state x in a certain year? >