How do I

J

Jody S

I have a list of states I travel in all month long (column A) and the miles I
travel listed in (column B) each time I go there.
I need to be able to pull the state and the mile for that state and get a
total for the month (for taxes) Does anyone know how??
Example:

A B
States Miles
GA 55
FL 50
KY 78
GA 78
AL 100
FL 99
AL 87
 
P

Paul C

Sumproduct will work for each state

=Sumproduct(--(A1:A10="GA"),B1:B10)

the --(a1:a10="GA") when true =1 when false=0 so will only total values
meeting the criteria

You can subsititute a cell ref (ie =D1) and copy down as needed
 

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

Excel problem 2
Lookup data in a variable table & retrieve data from a pivot table 3
If(not(A2="FL","AL".... ),"other",A2) IF(not help 3
Max number of Occurrence 5
Formula for Minimum/Maximum 2
How do I group states into regions? 6
Finding a value based on contents of two cells 3
Linking two worksheets 3

Top