View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
belvy123 belvy123 is offline
external usenet poster
 
Posts: 71
Default carry down total

Hi All


I have a sheet where I have 3 columns of 35 rows where I input numbers from
3 different presses production. in a 4th column I total that shifts
production and in a 5th column I have a running total of all rows that have
been entered.

What I need is a formula that if I have 1 row that is empty in all 3 columns
it will carry down the running total for that row and if it has 2 or more
rows where all 3 columns are blank that it will not carry down that running
total
--
crunchnin numbers