Good afternoon, a while back i had some help with a formula on the attached sheet. I need to update it now. The strengths are going to stay the same, but the weaknesses (purple headers on spreadsheet) only have to show up if the value associated with it is 3 or greater. (So traits with quantities of 1 and 2 will not show up as a weakness)
I have attached a spreadsheet wit desired results.
Thanks for all of the help
Los
Try this in your total points column:
=(SUM(D3:O3)*5)+(SUMIF(P3:W3,">2",P3:W3)*-2)
not sure how that would help? I am looking only to return character traits that have a value of three or greater in the weaknesses columns
Los
Please see the attachment, your example on the left has your original formula, but I have removed all of the 1 & 2's from it to get the totals you are looking for, the example on the right I have left in the numbers 1 & 2 but applied the formula I suggested, please note that the totals are the same.Originally Posted by Losguapos1
Original formula:
=(SUM(D3:O3)*5)+(SUM(P3:W3)*-2)
Suggested formula:
=(SUM(D3:O3)*5)+(SUMIF(P3:W3,">2",P3:W3)*-2)
By changing the second portion of your formula, I have basically said only to sum the digits if they are greater then "2". You will need to adjust the cell references (D3:03) the yellow area and (P3:W3) the purple area to what they are on your actual original spreadsheet.
Last edited by Dbradford1; 01-23-2014 at 12:48 PM.
still need a solution....anyone have any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks