Forum Discussion
Just lost my work and need help with quick formula -
My spread sheet has a column with the sum of each row. I would like to take that sum column and multiply it with the cost per item column have that sum=cost per item x sum of items shipped in t...
If I understand what you wrote correctly, this should work:
In cell CU5, enter =CS5*CT5
Then highlight cells CU5:CU77
Select Fill>Down
This should copy the formula from CU5 into all the cells in column CU and cause each row to display its own product in that column.
Hope this works. Have fun!