Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Excel 2000

Started by jdp , Jul 23 2007 12:24 PM

Please log in to reply

#1
jdp

Posted 23 July 2007 - 12:24 PM

New Member

Member
9 posts

I have an Excel spreadsheet and I want to find the cells that add up to a given sum. Is there a formula for this?

#2
Vino Rosso

Posted 23 July 2007 - 12:48 PM

Visiting Staff

Visiting Consultant
235 posts

Can you give any more info or show an example?

#3
jdp

Posted 23 July 2007 - 12:59 PM

New Member

Topic Starter
Member
9 posts

Customer Sales
A $100.00
B $110.00
C $120.00
D $150.00
E $200.00
F $250.00

I would like a formula that will find the 2 or more Sales cells that when added together equals $270.00. There may be more than one solution but I want it to find and show me those cells.

Thanks,