how to do formula

[Guest]

Need help on how to do formula on spreadsheet, build a spread to keep track
on fuel for taxes. Is there any way to calculate total of fuel for each
state, on spread sheet on each roll is unit number, whom, where(Okla, Texas,
ect.), and how many gallon for fuel. Trying to do formula on states where
fuel is bought to calculate total fuel bought from each state, like if its OK
then it'll total all gallons for that state, if its TX it'll total all gallon
for that state. Any help?

 

[Guest]

Assume State is in column A and gallons in column B

=SUMPRODUCT(--(A2:A100="TX"),B2:B100)

Better if you put the State(s) in a cell and use:

=SUMPRODUCT(--(A2:A100=H2),B2:B100)

where H2="TX" (for example)

 

[Guest]

This really help. One question, is there any way to do this in color? If I
dont use state but use color like if roll is yellow for Tx and orange for Ok?