C
Connie
Working with Excel 2000. I have several columns where I
need take the sum a variety of units of measure (UOM),
which is a mix in each column, BUT the unit of measure is
preceded by a number (within the same cell) which could be
any number. So, for example, in a column I could have
something like the following:
3,199 CAR (this would be in one cell)
1,113 CAR (same thing...in one cell)
1,075 MU (in the same cell)
22.9 CAD / CAR (in the same cell)
1.20 CAD / CAR (in the same cell)
975 MU
So, you see I have, in this example, two different types
of unit of measure (CAR and MU) in this column of
numbers. This is a huge file downloaded from Business
Warehouse and I cannot change any of the formatting. It
must remain as it is. What formula would I use (if
possible) to sum up all the numbers where the UOM
is "CAR", for example? In the example above, the total of
that column for CAR would be 4,336.1. I have 547 rows of
numbers in a very complex worksheet. I will also be
summing the UOM, MU, as well.
need take the sum a variety of units of measure (UOM),
which is a mix in each column, BUT the unit of measure is
preceded by a number (within the same cell) which could be
any number. So, for example, in a column I could have
something like the following:
3,199 CAR (this would be in one cell)
1,113 CAR (same thing...in one cell)
1,075 MU (in the same cell)
22.9 CAD / CAR (in the same cell)
1.20 CAD / CAR (in the same cell)
975 MU
So, you see I have, in this example, two different types
of unit of measure (CAR and MU) in this column of
numbers. This is a huge file downloaded from Business
Warehouse and I cannot change any of the formatting. It
must remain as it is. What formula would I use (if
possible) to sum up all the numbers where the UOM
is "CAR", for example? In the example above, the total of
that column for CAR would be 4,336.1. I have 547 rows of
numbers in a very complex worksheet. I will also be
summing the UOM, MU, as well.