LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default calculate various cells to acheive a specific value

Hello,
I am trying to identify two cells within a column that total a specific
amount. For example:

ColA
546
9732
654
6548
687
9871

I need to find the two (or more cells in some cases) that would create the
total of 10,525.

For my current task, I have over 100 rows of data and I know two cells equal
a specific amount, but I do not know which two. Any help, or assistance given
would be greatly appreciated!

Jennifer

 
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
I want to calculate Sundays between a specific date & today () Zahid Khan Excel Discussion (Misc queries) 2 April 3rd 07 09:13 PM
how calculate the date someone had to be born to have a specific a AAlvarez Excel Discussion (Misc queries) 3 February 8th 07 08:28 PM
Calculate max value in specific range NoSpamPlease Excel Discussion (Misc queries) 2 August 11th 05 04:10 PM
Only calculate specific worksheet automatically? qflyer Excel Worksheet Functions 1 June 27th 05 09:52 PM
How do I calculate specific data across worksheets? Alus Excel Worksheet Functions 2 January 6th 05 07:41 PM


All times are GMT +1. The time now is 07:11 PM.

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

About Us

"It's about Microsoft Excel"