Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
NauNoviceCopper ContributorJan 06, 2019COUNTIF Formula Help Hello, I am fairly new to working with Excel so please forgive me if this is a silly question. I have a set of data values in B2:G20. Let's say in row B20:G20 I have 2 values that match the values i...Show More
Willy LauSteel ContributorJan 07, 2019=SUMPRODUCT(COUNTIF(B20:G20,{8,17,24,43,48})) NOTE: hope that it is not used to check lottery result.
NauNoviceCopper Contributor to Willy LauJan 07, 2019Thank you! Looks like I need to dig deeper into understanding arrays. Also no worries about lotto results, losing money is not my thing lol
NauNoviceCopper Contributor to Willy LauJan 07, 2019Thank you! Looks like I need to dig deeper into understanding arrays. Also no worries about lotto results, losing money is not my thing lol
