Excel problem

J

Jody S

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!!
 
L

Luke M

Lets say you have a list of states in column C, with "GA" being in C1.
In D1:
=SUMIF(A:A,C1,B:B)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top