Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 64
Default Analyze Range of Cells

Can excel look at a range of values (number) and tell me if any of the cells
add up to a specific number?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 301
Default Analyze Range of Cells

Yes, using Solver.

"Rhonda" wrote in message
...
Can excel look at a range of values (number) and tell me if any of the

cells
add up to a specific number?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Analyze Range of Cells

Yes... This topic is very well covered in:

http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu200715
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 64
Default Analyze Range of Cells

I don't want it to change my existing values, I want it to see if any
combination of my values will = a specified number.

"Bob Umlas" wrote:

Yes, using Solver.

"Rhonda" wrote in message
...
Can excel look at a range of values (number) and tell me if any of the

cells
add up to a specific number?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
analyze list alex Excel Worksheet Functions 4 April 12th 07 08:42 PM
Analyze Data tokentrinkit Excel Worksheet Functions 3 August 18th 06 08:01 PM
Analyze with Excel from Access Bevatron Excel Worksheet Functions 2 April 24th 06 03:50 PM
how to analyze freight expense? boots Excel Worksheet Functions 1 June 25th 05 11:59 PM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"