Good afternoon people. Thank you in advance. These forums are awesome and I appreciate it.
Have 1 sheet with 2 columns (columns D and F) have numbers in them, if more than 1 number, then commas are used to separate numbers, so 1 comma per 2 numbers, 2 commas per 3 numbers and so on.
In a separate column, (column I), need formula that counts the total amount of numbers and then multiplies the sum by 1200 for each row going down.
Example:
Row 7 has column D with (139, 123, 343) and column F with (134), in column I, essentially would be (4 numbers times 1200 equals 4800)
In other words each number, regardless of amounts in column D and F equal 1200 each equally.
Thank you again in advance.
- Nary
Bookmarks