Logical Formaula

[Hassan]

Hi All,
first i should thanks to men who share their expertise earlier.
this time again i am looking for a logical formula for to calculate simple
addition in the fifth column with the condition that it should satisfy in all
previos columns (off course not for the first one)

A B C D E
1 + 2 + 3 + 4 = 10
--- + 2 + 3 + 4 = ----- (should leave blank)
1 + ---- + 3 + 4 = ----- (should leave
blank)

and so on.. until D

Ultimatly it should add up if there are a desired values in all previous
cells (some thing like a combination of double if & and

 

[Bob Phillips]

There are women as well!

=IF(COUNTA(A11)+4,SUM(A11),"")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Hassan]

Thanks for the answer!

but sorry to write i placed my question wrongly

below i try to write correct

WC QC Sub App % Complete
70% 10% y or n y or n

100% 100% y

100% y

Basically first column is work completion for me (70% weightage), second
column QC check (10% weightage) and this column is Submission (10% weightage
and denoted by “y†or “nâ€) and forth column is Approval (10% weightage and
denoted by “y†or “nâ€)
Technically once the Work is completed it should go to QC and so on and for
calculation it should not consider the values if previous stage is not
complete.

Logically I want answer in % Complete as
70% of 100% of WC+10% of 100% of QC (WC being 100 for that row)+10 (if it is
“y†in sub column and WC & QC being 100 for that row)+ 10 (if it is “y†in
App column and WC, QC being 100 and “y†in “Sub†for that row)

If any condition does not satisfies it should terminate and summation should
be upto previous column

Hope this would help Bob to understand and he will help me out!

Regards,

 

[Hassan]

Thanks for the answer!

but sorry to write i placed my below question wrongly

below i try to write correct

WC QC Sub App % Complete
70% 10% y or n y or n

100% 100% y

100% y

Basically first column is work completion for me (70% weightage), second
column QC check (10% weightage) and this column is Submission (10% weightage
and denoted by “y†or “nâ€) and forth column is Approval (10% weightage and
denoted by “y†or “nâ€)
Technically once the Work is completed it should go to QC and so on and for
calculation it should not consider the values if previous stage is not
complete.

Logically I want answer in % Complete as
70% of 100% of WC+10% of 100% of QC (WC being 100 for that row)+10 (if it is
“y†in sub column and WC & QC being 100 for that row)+ 10 (if it is “y†in
App column and WC, QC being 100 and “y†in “Sub†for that row)

If any condition does not satisfies it should terminate and summation should
be upto previous column

Hope this would help Bob to understand and he will help me out!

Regards,
One & All