Count data based on color of cell with criteria

hi,
i have data in sheet "ENTRY" range B10:B1000 and yellow color in range K10:K1000

i want to count yellow color in sheet "SUMALL" in range F11:F1000 According to range E11:E1000

I Added a sample workbook and some demo data

oops! uploading file is not working at my side
so uploading sample another site, if this is not in rule to upload sample on another site please pardon me
thank you


https://volafile.org/get/dmFWBjsTE44u/sample.xlsx

One way:

Please Login or Register  to view this content.

=SUMPRODUCT(('OL BC'!$B$10:$B$22=SUMALL!E11)*testColour('OL BC'!$K$10:$K$22,SUMALL!$F$10))

using F10 as the source of the reference color.

How to install your new code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
[B][I]


If it's too slow, delete "Application.volatile" and remember to recalculate (f9) after any shadings are changed.

Yes,
it worked as i need

thank you dear Forum Guru

You're welcome and thanks for the Rep.