Thanks:  0
Likes:  0

# Thread: Formula for totaling certain values

1. 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

2. Hi Matt

Sounds like SUMIF should suffice

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

_________________
Kind Regards
Dave Hawley
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-03-12 02:20 ]

3. 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?

4. Hi Matt

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•