sumproduct
Thanks for your early reply CMK, I am very sorry as I was unable to tell you
my exact purpose.
I want to do it in this way:
A B
yes no
no yes
yes no
no yes
yes yes
if "A" has "Yes" and "B" has "NO", it should be counted as 1
if "A" has "NO" and "B" has "Yes", it should be counted as 1
if "A" has "Yes" and "B" has "YES", it should be counted as 1
So, the answer at the end in this example is 5. Any reply would be highly
appreciated
"CmK" wrote:
Hi
Don t really get what your trying to say but what I can comprehend from this
here is my suggestion why dont you use the
IF function =if(a2="yes" and b2="yes",1,0)
Hope this helped
"Ome r" wrote:
I need one help too :)
I want to find number of "yes" in both columns but if yes is in both columns
it should be counted as 1
for example
A B
yes no
no yes
yes no
no yes
yes yes
The answer should be 5
I tried the formula =SUMPRODUCT((A1:A5="Yes")*OR(B1:B5="YES")) but its not
giving me the right answer, its giving me 3. Can any body please tell me it
in Sumproduct form as I have to compile the resuolt with other columns too
|