Formula appears, but its function is not performed?????

S

shelia

Column B has numbers brought from a separate sheet.
Column C has numbers that I "paste" in.
Column D has a formula to multiply B X C. This function is not performed
unless I highlight the formula in the formula bar and hit "enter".
Column E has a formula to get the average of the sum of 12 rows in Column D:
=ROUND(SUM(D2:D13)/SUM(B2:B13),0)
This formula is not automatically working, either. How can I fix this to
where the formulas are working when the column is populated with data?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional sum, when condition has multiple values 3
countifs Function not giving desired result with date criteria 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Copying formulas across columns 2
series of formulas to get to one formula 0
Avoiding auxiliary cells 0
Use TODAY() function as the criteria in a SUMIF formula 1
Sum Function Visible Cells only 5

Top