IF SUM commands

Closed
Videk
Posts
1
Registration date
Tuesday August 6, 2013
Status
Member
Last seen
August 7, 2013
- Aug 6, 2013 at 03:04 AM
Hi!
I have a column with number of mice drinking water..
5
3
8
7
15
10
=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!