Count receipts using cell colour

[JamesPeterCharles]

Hello, I'm currently working for a company selling phone cases and other accessories and, even tho they don't really care about their own Excel files, I do, as it makes the workflow much more convenient.

Recently, my manager has asked me if I could come up with a formula for automatically counting the number of receipt (not the individual items) per person.

I have actually found a way to make it work but it involves adding another column of cells, and I would really like to wow my manager and show her that I could do it without altering anything.
If any of you can help me, I would be more than happy, if not, I'm grateful anyways! Thank you !!!

 

[Joe4]

Welcome to the Board!

Excel formulas do not work off of formatting. So you really cannot sum by color without using VBA.
But I don't think you need to. I think you should just be able to use a SUMIF formula to sum the value per Worker field ("A", "B", "C", etc).
See: Excel SUMIF Function