lui_roc
03-04-2006, 11:31 AM
I would like a formula to total the risk impact columns (cost, time, safety, quality and impact quotient), which are only negative values, based on the likelihood.
In the likelihood column value:
1 = Rare
2 = Unlikely
3 = Possible
4 = Likely
5 = Almost Certain
For example, the formula for cell G22 on the project register sheet will sum every negative cost value (column G) that has a likelihood (column F) of 1.
I hope that makes sense
My thanks in advance
Lui
Attached Fileshttp://www.vbaexpress.com/forum/images/attach/xls.gifRiskRegister_V18.xls (http://vbaexpress.com/forum/attachment.php?attachmentid=2868&d=1141495057) (66.0 KB, 0 views)
In the likelihood column value:
1 = Rare
2 = Unlikely
3 = Possible
4 = Likely
5 = Almost Certain
For example, the formula for cell G22 on the project register sheet will sum every negative cost value (column G) that has a likelihood (column F) of 1.
I hope that makes sense
My thanks in advance
Lui
Attached Fileshttp://www.vbaexpress.com/forum/images/attach/xls.gifRiskRegister_V18.xls (http://vbaexpress.com/forum/attachment.php?attachmentid=2868&d=1141495057) (66.0 KB, 0 views)