Excel - 'find me the numbers that add up to this'? | AccountingWEB

Excel - 'find me the numbers that add up to this'?

This happens to me more often than you'd think, so a shortcut would be a help!

A client (or sometimes a colleague) will present a column of numbers on Excel and note that they have claimed £x from it, but make no mention of which numbers have been used.

Case in point, a client gives me a list of 50+ items all neatly laid out.  They tell me '£2,895 of these expenses I think are private'.  Great, but which ones are they?!?  Can Excel somehow find me the cells that would add up to that total?  Or am I asking too much :)

Otherwise it is a bit of trial and error (that £3,000 expense clearly doesn't feature, but a lot of them are well under £2,895).

There are 22 comments. Login or register to view them.

I don't know..

cyrynpen |

Have you tried...

George Attazder |
George Attazder's picture

IIRC there is a way

ACDWebb |
ACDWebb's picture

Ask the client

cyrynpen |

If your clients are anything like ours

Constantly Confused |
Constantly Confused's picture

Well ...

bigdave1971 |

Yes ....solver

landscaper |
landscaper's picture

And next month...

WhichTyler |


aiwalters |
aiwalters's picture


nogammonsinanundoubledgame |
nogammonsinanundoubledgame's picture

Can't please some people...

steve.oldham |

semi-automatic method...

AdShawBPR |

Add another

rayhelmke |


jndavs |
jndavs's picture


kathyray |


ACDWebb |
ACDWebb's picture


jndavs |
jndavs's picture


David Taylor |
David Taylor's picture

Forgive an 'outsider' ...

David Winch |
David Winch's picture

Numbers problem.

Thorold |

Excel add -in may help

catpol123 |

This helped a lot

marijn bax |