Counting Errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
If A1 is crates and B1 bottles

=A1+INT(B1/24)&" crates "&MOD(B1,24)&" bottles"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top