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 the next column.
sum item shipped is in CS column CS5:CS77
price per item is in CT column CT5:CT77
Sum of CS*CT to post in CU5:CU77
1 Reply
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!
