- 1). Open the Microsoft Excel 2010 application on your computer, then click the “Microsoft Office” button.
- 2). Click the “Open” option, then select the Excel 2010 spreadsheet for which you want to use the LOOKUP function. Click the “Open” button.
- 3). Enter “=SUMIF” into the top function bar of your spreadsheet.
- 4). Enter the column range and the sum you want totaled into parentheses. For example, if you enter “(C2:C10,”=50”), the function will search the rows in column C for all sums that equal 50.
- 5). Press the “Enter” key to see the sums that are equal in the same column. You can then repeat this process for other columns.
- 6). Enter “=LOOKUP” into the top function bar, then enter the range of your spreadsheet in which you want to look for matches of sums. For example, entering “(50, A2:A10, B2:B10)” will bring up all similar sum totals in columns A and B.
- 7). Press the “Enter” key on your keyboard and all the sums with in the range will become automatically highlighted on your spreadsheet.
EDITOR PICKS & Articles
- Self-Fulfilling Prophecies - How Do They Fit Into Our Lives?
- Manifesting Your Power to Create Your Own Wealth
- What You See Is What You Get!
- The Salve of Tolerance
- 5 Secrets On The Importance Of A Coach
- Are You Failing in the Present?
- How to Make BIG Changes in your Life When you are Stuck!
- Guidelines For Living
- How to Get Your Way and Come Out Unscathed
- Don"t Wait - Celebrate!
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time
Stay With Us