Combining the results of two coloured cells into one

Hi Everyone,

Thanks in advance for anyone that reads this and tries to help!!!!

What im looking for, if possible, is to be able to be to sum the total of two columns, with two different colours into one column. In the attached example. 21C, appears in a white, peach and red colour. I already have a macro that lists the colour to the right that i reference. But now im trying to combine the totals of anything in peach Colour 8696052 + anything in white color 16777215 into one cell, minus the sum of -SUM(BX155,CD155,CG155)

=COUNTIFS($Z$25:$Z$151,BV155,$AB$24:$AB$150,8696052,$AB$24:$AB$150,16777215)-SUM(BX155,CD155,CG155) - this is the current formula im trying but not working


Hopefully my explanation makes sense, again thanks in advance to anyone that can help with this!!!

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. I have done it for you this once.)

Where is the formula?

@Glenn CA156

Administrative Note:

It has been under two hours since you first posted. Please do not bump threads until 24 hours have passed, and then only once each day. We are all volunteers here who have lives beyond this forum. While you may be awake and working, this is a world wide forum and others may be playing, sleeping or working and not have the time to look into your issues this minute. Patience is important here. If you have an urgent issue, you may wish to look at paying for help in the Commercial Services sub-forum or hiring a professional consultant in your area. Again, please do not bump threads more often than once in every 24 hours: if you get the help you need today, then great, but you really should not count on it. Thanks for your understanding and patience.