Thread: Display the cells which add up to a certain sum
View Single Post
 
Old 11-24-2009, 08:00 AM
edbyford edbyford is offline Windows 7 Office 2007
Novice
  
Join Date: Nov 2009
Posts: 1
edbyford is on a distinguished road
Default Display the cells which add up to a certain sum
Hello all

I have a list of foods and calorie values in Excel. What I want to do is be able to specify a certain value (say 250 calories) and have Excel display the foods which calorie values approximately add up to that total. This could then be used for meal planning.

Can you help me please?
Reply With Quote