Formula for totaling certain values

[Matt]

I need to check if any of the values in the range of A69 to A90 are less than 2. If they are less than 2, I want to total them and return the value to H88.

I then wish to create a graph over the range A69 to A90 exclusing all values of less than 2. I'm not sure at this stage whether it is easier to do the whole process using code or by inserting the formula into a template. Any suggestions will be greatly appreciated.

thanks

Matt

 

[Dave Hawley]

Hi Matt

Sounds like SUMIF should suffice

=SUMIF(A69:A90,"<2")

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

This message was edited by Dave Hawley on 2002-03-12 02:20

 

[Matt]

Thanks Dave

Any ideas how I can then suppress all the values under 2 from appearing in a graph within the range of A69 to A90?

 

[Dave Hawley]

Hi Matt

Easiest way is to hide the Rows or Columns of these cells.