Running Totals for Descriptive Cells

[tz1154]

I am trying to total gallon usage across different states. When the driver leaves 1 state and goes into another I want them to make note of that but then I want them to total for each state in a different box. See below and it may make things clearer.

STATE Gallons Date AL GA
AL 25
GA 32
AL 25


Here the driver has driven in AL then GA then again in AL. AL should read 50, and GA should read 32.

Any ideas???

[Bob Phillips]

Try

=SUMIF(A:A,$A2,B:B)

[tz1154]

Thanks Bob!

I had to change it a bit

=SUMIF(A3:A10,$A3:A10,B3:B10)

but only because of formatting.

I expect a few more problems with trying to get all of the different states to work, but thanks for getting me pointed in the right direction!

[Bob Phillips]

If you will be testing many states, you should fix the ranges. And the middle argument should be a single cell

=SUMIF($A$3:$A$10,$A3,$B$3:$B$10)

[tz1154]

Sorry I'm a dufus. I just had to switch the Criteria reference

[tz1154]

STATE Gallons Date AL AK
AL 12 25 25
AK 2
AL 13
AK 5
--


This is what I'm getting so far. I realize it might be because of the extra 'date' column