View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AINS AINS is offline
external usenet poster
 
Posts: 1
Default SPREAD SHEET FORMULA

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