I am trying to add two ranges of cells, then trying to divide them by a number. I keep getting errors and I am stuck. I am inputting =sum(B4:F4)-sum(M4:Q4)/5
B4:F4 = 5
M4:Q4= 4
5 - 4 = 1
1/5 = .20
can someone help?
I am trying to add two ranges of cells, then trying to divide them by a number. I keep getting errors and I am stuck. I am inputting =sum(B4:F4)-sum(M4:Q4)/5
B4:F4 = 5
M4:Q4= 4
5 - 4 = 1
1/5 = .20
can someone help?
Last edited by Fllyfishy; 11-12-2011 at 03:54 PM.
How about:
Cheers,Please Login or Register to view this content.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
Thank you,
Following up on @ConneXionLost's excellent post, notice that there are brackets around the sums before the division. Excel has a priority when calculating so the result for:
is different fromPlease Login or Register to view this content.
Hope this helps.Please Login or Register to view this content.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
I did notice the extra brackets. Thank you for the quick replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks