View Single Post
  #1   Report Post  
bill gras
 
Posts: n/a
Default add cells if the value of another cell =?

I have in cell F26 numbers from 0-24, I need to ad together cells K52 and J52
only if cell F26 does not contains number 1, if cell F26 contains number 1, I
do not add cells K52 and J52 together, Ijust need cell K52 on its own.
I'm using excel 2000

Can any one please help

regards bill gras