Help figuring out $ in one column with conditions based on other columns

**Alinkowski** · 01-30-2013, 03:01 PM

I am working on a follow up survey that will give me the % of people who answered "yes" in columns GHI also answered yes in column D, also if "YES" Yes in column E but No in column G.Excel Help.xlsx

**K m** · 01-30-2013, 03:12 PM

...answered "yes" in columns GHI also .....but No in column G

The answer is none.

Column G can not be both Yes and No
===========================================
Did you mean two conditions?:
- Condition 1 - Yes to D,G,H and I
- Condition 2 - Yes to E and no to G

**Alinkowski** · 01-30-2013, 03:25 PM

sorry, yes that is what I meant.
1) If they answered yes to GHI, % that said yes to column D
2) If they answered No to column G, % that said yes to column E

**K m** · 01-30-2013, 03:45 PM

Put this formula in cell D5 and copy down
=IFERROR(IF(AND(G5="Yes",H5="Yes",I5="Yes"),1,0),"")

Put this formula in cell E5 and copy down
=IF(ISNA(IF(G5="yes",1,0)),"",IF(G5="yes",1,0))

The percentage is the SUM divided by the COUNT *100

**Alinkowski** · 01-30-2013, 04:40 PM

If I do that it changes the data in those cells(D5 and E5)for "yes" or "no" to a number.

**K m** · 01-30-2013, 05:12 PM

It will return either a blank, 0 or 1. Blank is there is an error, zero if there is no match and one if there is a match. To get a percentage from there should be easy as it is sum/number of entries times 100

**FDibbins** · 01-30-2013, 05:12 PM

for D,G,H,I = YES...
=COUNTIFS($D$5:$D$25,"YES",$G$5:$G$25,"YES",$H$5:$H$25,"YES",$I$5:$I$25,"YES")
for G=no, E = YES...
=COUNTIFS($G$5:$G$25,"NO",$E$5:$E$25,"YES")

Not sure how you want to work out the %, but that will give you the qty