COUNTIF, SUMPRODUCT, or something else

  • Thread starter Thread starter Count-Adi
  • Start date Start date
C

Count-Adi

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
 
=SUMPRODUCT((C1:C18=1)*(D1:E18="Yes"))



Count-Adi said:
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
Click to expand...
 
Back
Top