Jul 24 2019 08:23 AM
In the attached file, I need Count (in col. M) of all the cells in a row (range B2: L2) that are highlighted in pink, how do I do that using some excel function
File is attached here for reference
Jul 24 2019 08:25 AM
Jul 24 2019 12:49 PM
I happened to see your post and made a search on the topic remembering that I have seen (but not used) cell coloring logic somewhere before.
I found this. Maybe this gives you something to dwell upon:
https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/
Mind you I know nothing more of the subject or ablebits.
Jul 24 2019 01:14 PM
In your case that could be
=SUMPRODUCT(--($B2:$H2>{0.06,8,6,10,3,0.5,0.5}))+SUMPRODUCT(--($J2:$L2>{10,1,1}))+($I2<100000000000)
just use logic of your conditional formatting rules. Please see attached.