Welcome Guest [Log In] [Register]
Assalamoalaikum, We hope you will enjoy your visit here.

Join our community!

If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Summing Values from a List; Excel tip
Topic Started: Jan 13 2007, 12:41 PM (136 Views)
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Summing Values from a List Containing Numerical and Textual Substrings

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))}

Offline Profile Quote Post Goto Top
 
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Posted Image
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Roshnee · Next Topic »
Add Reply