IF Function Including Count Colour

I was able to count cells by their background color by the following:

Function CountColour(rng As Range, clr As Range)
Dim c As Range
For Each c In rng
    If c.Interior.ColorIndex = clr.Interior.ColorIndex Then
        CountColour = CountColour + 1
    End If
Next
End Function

However, I need to add an IF function to this module… Any suggestions????

I am not very proficient in Excel and simply adding the module was a big win, but I’m not quite there yet… :/

PLEASE HELP ME!

2,843 thoughts on “IF Function Including Count Colour

  1. udfauzi.com

    I’m impressed, I must say. Rarely do I come across a blog that’s equally educative and interesting, and without a doubt, you’ve hit the nail on the head. The problem is something that too few men and women are speaking intelligently about. Now i’m very happy that I stumbled across this in my search for something relating to this.

  2. HP printer driver

    I’m amazed, I must say. Rarely do I encounter a blog that’s equally educative and engaging, and without a doubt, you have hit the nail on the head. The issue is something which not enough men and women are speaking intelligently about. I am very happy that I found this during my hunt for something concerning this.

  3. iamgutsclub.com

    That is a very good tip especially to those new to the blogosphere. Simple but very precise information… Appreciate your sharing this one. A must read article!

  4. toko online 88

    Nice post. I learn something totally new and challenging on blogs I stumbleupon everyday. It will always be useful to read through content from other writers and practice a little something from other websites.

  5. genolyze.com

    Greetings! Very useful advice in this particular article! It’s the little changes that will make the largest changes. Thanks a lot for sharing!

  6. fancy text

    Wow, wonderful weblog format! How long have
    you been blogging for? you made running a blog look easy.
    The entire glance of your site is magnificent,
    let alone the content material!

  7. App Smart Iptv Samsung

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  8. vivoslot.net

    You’ve made some really good points there. I checked on the web for more information about the issue and found most people will go along with your views on this site.

  9. vivo slot

    Hi there, I do think your website could be having web browser compatibility issues. When I take a look at your website in Safari, it looks fine however when opening in Internet Explorer, it’s got some overlapping issues. I merely wanted to give you a quick heads up! Aside from that, great site!

  10. vivo slot

    After looking into a number of the blog articles on your blog, I really like your technique of writing a blog. I saved as a favorite it to my bookmark webpage list and will be checking back soon. Take a look at my website too and let me know what you think.

  11. login vivoslot

    An interesting discussion is worth comment. I do believe that you should write more about this topic, it might not be a taboo subject but typically folks don’t talk about these subjects. To the next! Kind regards!!

  12. sbobet asia

    I am extremely inspired along with your writing skills and also with the format on your weblog. Is that this a paid theme or did you customize it your self? Anyway stay up the nice quality writing, it is rare to look a nice blog like this one nowadays..|

  13. 192.168.0.1

    You have made some decent points there. I checked on the web to learn more about the issue and found most people will go along with your views on this web site.

  14. togel online

    I have to thank you for the efforts you’ve put in writing this site. I’m hoping to check out the same high-grade blog posts from you in the future as well. In fact, your creative writing abilities has encouraged me to get my own, personal site now 😉

  15. vivoslot mobile

    Hello there! This post could not be written any better! Looking through this article reminds me of my previous roommate! He continually kept preaching about this. I most certainly will forward this information to him. Pretty sure he’s going to have a great read. Thanks for sharing!

  16. togel sydney

    Everything is very open with a very clear explanation of the challenges. It was truly informative. Your site is useful. Thank you for sharing!

  17. vivoslot login

    The next time I read a blog, I hope that it does not fail me just as much as this particular one. I mean, Yes, it was my choice to read through, however I genuinely believed you would have something helpful to say. All I hear is a bunch of crying about something that you can fix if you weren’t too busy looking for attention.

  18. daftar akun vivoslot

    Having read this I believed it was really informative. I appreciate you spending some time and effort to put this article together. I once again find myself spending a significant amount of time both reading and commenting. But so what, it was still worthwhile!

  19. dingdong togel

    Nice post. I learn something totally new and challenging on blogs I stumbleupon everyday. It will always be useful to read through content from other authors and practice a little something from other web sites.

  20. dingdong togel 36d

    Oh my goodness! Impressive article dude! Many thanks, However I am encountering problems with your RSS. I don’t know the reason why I am unable to subscribe to it. Is there anybody else having similar RSS issues? Anyone that knows the solution can you kindly respond? Thanx!!

  21. obat penggugur kandungan

    I will right away clutch your rss as I can not in finding your email subscription hyperlink or e-newsletter service.
    Do you’ve any? Please allow me understand so that I could
    subscribe. Thanks.

Comments are closed.