Function to add 3 column (of YES) to give a total % complete

P

preyesone

I am trying to write a formula that will allow me to add a Yes to one cell
(in 3 different columns) cell and then give a % as the answer
For example:

Cell A1 = Yes Total would be 40%
Cell A2 = Yes Combined (A1+A2) Total would be 70%
Cell A3 = Yes Combined (A1+A2+A3) Total would be 100%

Any and all help is appreciated!
 
E

Eduardo

Hi,
try

=IF(AND(a1="YES",a2="YES",a3="YES"),"100%",IF(AND(a1="YES",a2="YES"),"70%",IF(a1="YES","40%","")))
 
P

preyesone

Thank you... Thank you... Thank you!

Eduardo said:
Hi,
try

=IF(AND(a1="YES",a2="YES",a3="YES"),"100%",IF(AND(a1="YES",a2="YES"),"70%",IF(a1="YES","40%","")))
 
K

Ken

A little different approach:

=INDEX({0;40;70;100},COUNTIF(D15:F15,"Yes")+1)

This assumes your "yeses" go in columns D, E, and F and that you want
a 0 if there are none.

Good luck

Ken
Norfolk, Va
 
S

Shane Devenshire

Hi,

here are two short approaches

Array enter
=SUM((A1:A3="yes")*{0.4;0.3;0.3})

to array enter this press Shift+Ctr+Enter

or create a range contain 40% 30% and 30%, in the example below B1:B3

=SUMIF(A1:A3,"yes",B1:B3)
 

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