Find cells within worksheet that add up to a certain value

A

Ashley P.

I have a column with values in 65 cells, and I'm trying to find out which
ones (if any) add up to a specific amount. It could be any two or more of the
cells, or none at all. I really don't want to try adding them all manually to
see if I can find the amount I'm trying to match. Can I use Excel to do this
instead?
 
T

TeddyBear

Joined
May 16, 2013
Messages
2
Reaction score
0
Try SumMatch (Excel Add in) from SumMatch com


Mike H said:
Hi.



"Ashley P." wrote:

> I have a column with values in 65 cells, and I'm trying to find out which
> ones (if any) add up to a specific amount. It could be any two or more of the
> cells, or none at all. I really don't want to try adding them all manually to
> see if I can find the amount I'm trying to match. Can I use Excel to do this
> instead?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do you add related cells in a sum? 3
find values that add up to certain amount 12
Excel Concatenate with line breaks but ignore blank cells 3
Check multiple cells for a match 5
Formulas do not add up to original value 3
NOT Printing certain cells within the print range 1
Finding a value by adding certain sums in a range? 2

Top