vegas86
asked on
Formula help
Hello,
Can someone please explain to me how I would get the following?
On the attached spreadsheet I have some data that I would like to add together.
I would like to count for example both column A and column H as one if they both say “Yes”
Would this be an IF statement?
example.xlsx
Can someone please explain to me how I would get the following?
On the attached spreadsheet I have some data that I would like to add together.
I would like to count for example both column A and column H as one if they both say “Yes”
Would this be an IF statement?
example.xlsx
ASKER
Hey Teylyn,
Sorry I worded that wrong. What you did is perfect but is there any chance i can do the entire columns at once? so count how many rows that have yes is both columns A and H and return a number?
Sorry I worded that wrong. What you did is perfect but is there any chance i can do the entire columns at once? so count how many rows that have yes is both columns A and H and return a number?
... or, if you're trying to count Yes's but treat A and H as one then...
=COUNTIF(A2:M2,"Yes")-AND( A2="Yes",H 2="Yes")
Please see attached.
Regards,
Brian.
example-V3.xlsx
=COUNTIF(A2:M2,"Yes")-AND(
Please see attached.
Regards,
Brian.
example-V3.xlsx
N1: BothYes
N2: =IF(AND(A2="Yes", H2="Yes"),1,0)
Copy down
O1:Total
O2:==SUM(N:N)
you can hide column N if you wish
N2: =IF(AND(A2="Yes", H2="Yes"),1,0)
Copy down
O1:Total
O2:==SUM(N:N)
you can hide column N if you wish
here how it works...
example.xlsx
example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all your help and suggestions guys. Thank you Teylyn the countif was exactly what i needed!
if you want to return a 1 if both column A and H in a given row equals Yes, then use in row 2
=IF(AND(A2="yes",H2="yes")
copy down.
cheers, teylyn