I have a column with number of mice drinking water..
=IF(A3>10, 300,IF(A3>=7, 250, IF(A3<6, 200))) was my command to get number of milliliters of water I need to provide each cage. And SUM is easy to do.
BUT what I want to do is to write a formula in one cell and get the result in one cell that will give me SUM of all milliliters, without making the column for milliliters.. Hope I wrote it clear.. =)
Thank you for your help!