Logical Formaula

H

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
 
B

Bob Phillips

There are women as well!

=IF(COUNTA(A1:D1)+4,SUM(A1:D1),"")

--
---
HTH

Bob


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

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,
 
H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top