» Summing Values from a List Containing Numerical and Textual Substrings
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Problem:Listed in columns A & B are file names and their sizes, each of which is one of three types (KB, MB or GB).
We want to sum the totals for each file size type.
Solution:
Use the SUM, IF, ISNUMBER, FIND, VALUE, and LEFT functions as shown in the following Array formula:
{=SUM(IF(ISNUMBER(FIND(C2,B2:B5)),VALUE(LEFT(B2:B5,FIND(C2,B2:B5)-1)),0))}
Book Store:
Recommended Books:
- Microsoft Word Version 2002 Inside Out
- Microsoft Excel 2002 Formulas (With CD-ROM)
- The New Financial Order: Risk in the Twenty-First Century
- How to Read A Financial Report
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Advanced modelling in finance using Excel and VBA
No comments have been submitted.
