Dear Excel Enthusiasts,
I have been working on an excel workbook to calculate how much money is spent when buying in from suppliers. In order to sort trough the massive list of suppliers i used a condition format to color the cells of the suppliers i need to calculate.
Because this list contains over 50.000 rows i need some kind of formula or function to sum up the amounts provided to me by the given color(blanks not included). I have looked around the internet for a solution but haven't found a proper one yet. Unfortunately i am not allowed to install any kind of excel add-on to my work PC so any of them won't do. I would be pleased if any of you know how i can make this work.
I attached the Example file of what i have managed to work up.
Thanks in advance.
With Kind Regards,
Rekragisao
Bookmarks