Calculating the sum of columns and then find average against another value
I am putting together a spreadsheet that will calculate totals in each column. In one of the columns I have totals paid to date for each row. I am trying to find the sum of those cells (rows 2 through 30) and then divide the sum against a total from another cell. How can I do that? I have tried the formula =SUM(P2:P12)/L13 but I get an error.
Is this even possible? It seems logical but I cannot figure out how to resolve the error.
Thank you,
Regina
I bet it is, but I think you get better help if you post an excel example, without confidentional information.
Please also add, the desired result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Please see below. Thanks for the suggestion!
I want to be able to get the sum from column P(Total Diversity Dollars Paid) P2:12 and then divide the total against column I (Contract Amount) cell 13.DATA EXAMPLE.jpg
In your original question you were dividing by L13, I assume that should be I13 like this
=SUM(P2:P12)/I13
It's a valid formula and should work as long as I13 is a number. If that doesn't work can you post the actual workbook (or a sanitised version)?
Audere est facere
If L13 has a formula within it's cell would that be why I am getting the error? L13 is capturing the sum of dollars?
What formula do you have in L13?
Does the SUM part work OK on its own - what do you get with
=SUM(P2:P12)
@reginaf
see the red text in the respond of daddylonglegs
Please Login or Register to view this content.
Thank you all! I did have the wrong letter associated with the column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks