Thread: Counting Errors
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tarique
 
Posts: n/a
Default Counting Errors

I have a problem to sum to columns. Please help....
Problem is that the first cloumn is containing the quantity of crates of
empty bottles. (24 bottles makes one crate). Second column contain the
bottles.
Third column will sum the values of two columns. If second column contain
the value of 24 then it count one crate. e.g;
Colunm1 Colunm2 Colunm3
(Crates) (Bottles) Total
55 16 ? (55 crates
& 16 bottles)
55 24 ? (Answer
will be 56)
? ? ? (Total)