D dimitrz New Member Sep 2, 2023 #1 Dear experts , need help in creating a formula to redistribute weightage incase one of the Cell value is "n/a" I have attached an excel file for ease of clarity Attachments weighted test.xlsx 17.7 KB · Views: 10
Dear experts , need help in creating a formula to redistribute weightage incase one of the Cell value is "n/a" I have attached an excel file for ease of clarity
D dimitrz New Member Sep 3, 2023 #2 I got an answer from a different forum posting the formula here so that it may help others =IF($H3="N/A","",$F3/SUMIF($H$3:$H$7,"<>N/A",$F$3:$F$7))
I got an answer from a different forum posting the formula here so that it may help others =IF($H3="N/A","",$F3/SUMIF($H$3:$H$7,"<>N/A",$F$3:$F$7))
V vletm Excel Ninja Sep 4, 2023 #3 dimitrz... incase one of the Cell value is "n/a" and later You wrote more Your gotten solution seems to work even if none of cells is "n/a". ... but ... if more means everything then there will be a challenge.
dimitrz... incase one of the Cell value is "n/a" and later You wrote more Your gotten solution seems to work even if none of cells is "n/a". ... but ... if more means everything then there will be a challenge.