Hi

=SUMIF(A1:A100,"=GA",B1:B100)

Regards,
Per

"Jody S" <Jody skrev i meddelelsen
...
Okay I have a speadsheet that goes like this
A b
GA 76876
GA 87798
FL 56567
TN 90997
GA 78876

I need to find the total miles for GA then FL then TN. So how do I write
the formula to pull the date from A and B and tell me how many mile I
traveled in each state all month long? Thanks to anybody who can answer
this
question!!