COUNTIF, SUMPRODUCT, or something else
Sorry, I have another question. What about having 30 columns from where I
should count these yes- values with the same condition? It will be a long formula. Is there anything else that might be shorter? Thanks "Per Jessen" wrote: Hi This should do it: =SUMPRODUCT(--(C1:C11=1),--(D1:D11="yes"))+SUMPRODUCT(--(C1:C11=1),--(E1:E11="yes")) Regards, Per "Count-Adi" skrev i meddelelsen ... I am trying to use COUNTIF function where the range might vary. For instance, I want to know how many yes I have in column D and E together, with the condition that C will be only equal with 1. C D E 1 1 Yes 1 Yes 1 2 Yes 2 2 Yes 3 Yes 3 Yes 3 Yes 3 {=COUNTIF(IF($C$1:$C$11=1,$D$1:$E$11,0),"yes€¯)} should be 2. Thanks for your help. |
COUNTIF, SUMPRODUCT, or something else
=SUMPRODUCT((C1:C18=1)*(D1:E18="Yes"))
"Count-Adi" wrote: Sorry, I have another question. What about having 30 columns from where I should count these yes- values with the same condition? It will be a long formula. Is there anything else that might be shorter? Thanks "Per Jessen" wrote: Hi This should do it: =SUMPRODUCT(--(C1:C11=1),--(D1:D11="yes"))+SUMPRODUCT(--(C1:C11=1),--(E1:E11="yes")) Regards, Per "Count-Adi" skrev i meddelelsen ... I am trying to use COUNTIF function where the range might vary. For instance, I want to know how many yes I have in column D and E together, with the condition that C will be only equal with 1. C D E 1 1 Yes 1 Yes 1 2 Yes 2 2 Yes 3 Yes 3 Yes 3 Yes 3 {=COUNTIF(IF($C$1:$C$11=1,$D$1:$E$11,0),"yes€¯)} should be 2. Thanks for your help. |
All times are GMT +1. The time now is 06:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com