COUNTIF, SUMPRODUCT, or something else

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
 
T

Teethless mama

=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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
New computer, how do i move outlook 365 ENTIRELY? 0
Drop down list control value in vba 2
Vlookup and Countif 0
COUNTIF or something else? 9
Countif, index and match 2
Getting Radio Buttons to work, that are inserted via AutoText 0
Help with Sumproduct searching cell contents 2

Top