| 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: |
| Summing Values from a List; Excel tip | |
|---|---|
| Tweet Topic Started: Jan 13 2007, 12:41 PM (136 Views) | |
| Ahmaq | Jan 13 2007, 12:41 PM Post #1 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
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))} |
![]() |
|
| Ahmaq | Jan 13 2007, 12:42 PM Post #2 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
Posted Image |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Roshnee · Next Topic » |








5:33 AM Jul 11