Formula for totaling certain values

Matt · Mar 12th, 2002, 03:17 AM

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 · Mar 12th, 2002, 03:19 AM

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 · Mar 12th, 2002, 03:26 AM

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 · Mar 12th, 2002, 03:44 AM

Hi Matt

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 03:17 AM	#1
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	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

Mar 12th, 2002, 03:19 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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 ]

Mar 12th, 2002, 03:26 AM	#3
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	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?

Mar 12th, 2002, 03:44 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Matt Easiest way is to hide the Rows or Columns of these cells.