I'm new here, so if this has been answered, maybe someone can direct me to a previous thread.
I am creating a table that has numbers down the left side and percentages across the top. I want to fill in the numbers in the table with the product of the correlating row/column. I have had zero success with putting in a function. Everytime I use the product function and highlight all of the empty cells in a row or column, it multiplies the previous cell, so it is a continuous equation, if that makes sense. Hopefully someone can help me--I've been wanting to complete this chart for 5 years, and I keep putting it off cause I don't want to have to calculate each individual cell with a calculator!
I am creating a table that has numbers down the left side and percentages across the top. I want to fill in the numbers in the table with the product of the correlating row/column. I have had zero success with putting in a function. Everytime I use the product function and highlight all of the empty cells in a row or column, it multiplies the previous cell, so it is a continuous equation, if that makes sense. Hopefully someone can help me--I've been wanting to complete this chart for 5 years, and I keep putting it off cause I don't want to have to calculate each individual cell with a calculator!