Chloe has attended:
Excel Intermediate course
Locating a total value in a group of values.
Hi,
Please can I get help, I have been tasked on the below would someone be able to help as I cannot work out how to do it.
We need to find all the rows that would make £287,337.72 exactly.
Please can you take a look and see if it’s possible to find a combination of rows that would make the £287k total.
Thanks in Advance for your help!
RE: Locating a total value in a group of values.
Hi Chloe
Thank you for using the forum to ask a question.
The solution to this problem is more detective work than an Excel solution. You will need to verify each line item and cross check.
You can use your mouse and holding the ctrl key to click on multiple cells, the SUM total will show in the bottom grey bar which gives you a quick calculation without formula.
Top tip: If a number is divisible by 9 an error has occurred where a number has been transposed e.g. 354 instead of 345
Kind regards
Richard
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
