You can learn more about the Excel Sumproduct function here: Formula Forensics 007 As there is only 1 array component in our formula, Sumproduct simply adds up the values. The formula is a Sumproduct() based formula which tells us that the Sumproduct() function is being used to multiply and addup the component arrays. This week at the Forums, Ajinka asked a question about counting unique values in a range.įaseeh answered with a neat Sumproduct() based formula and quoting a post that Chandoo had written at answering the question in 2009.Ī few people asked how it worked and Luke M gave a good response which I will be plagiarising in part here.įaseeh’s formula was =SUMPRODUCT(1/COUNTIF(B2:B8,B2:B8))Īs always at Formula Forensics you can follow along using a Worked Example which you can download here: Excel 97-2013. Formula Forensics, Huis, Posts by Hui, wonder why - 25 comments
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |