SPREAD SHEET FORMULA

[AINS]

I HAVE A SPREAD SHEET THAT I CANNT SORT WITHOUT MESSING UP THE FORMULAS THE
LAY OUT IS AT FOLLOWS

A B C
D
STATE ODOMETER START ODOMETER STOP MILES
PA
OH
NJ
CT
NH


I NEED A FORMULA TO ADD EACH STATES MILES AND OF COURSE THEY ARE NOT IN
ORDER, I NEED MY FORMULA TO RECOGNIZE THE STATE AND ONLY ADD THOSE MILES
TOGETHER??? HELP

 

[Rick Rothstein]

If you understand your question correctly, this formula should give you the
totals you want...

=SUMPRODUCT((A2:A1000="NJ")*D21000)

Just change the "NJ" to the state you want and change the range to cover the
maximum number of rows you think you will need (make sure the A range and
the D range are the same size).

 

[Don Guillett]

Have a look in the help index for SUMIF. And, please quit SHOUTING. (typing
in all caps is considered to be RUDE)