Sum with 2 conditions

Hi All

I am trying to solve one function that keeps me awake at night.

I need to sum data under two conditions

if in column A data is not marked green & in column B in respective row chosen txt is shown ( different sites, paris, madrid etc) then sum respective positions in column A
I managed to get close with following function however if there is more then 1 marked green then it breaks the sumup
=SUMIFS($A5:$A369 ; $B5:$B369 ; B195(cell with the txt) ; $B5:B369 ; SummeWennFarbe(A5:$A369;$B$39(cell with green colour)))

You get better result on your question if you add a small excel file, without confidential information.

Please also add the expected results manualy in your file.

when i click on the file I get the message below.

Invalid Attachment specified. If you followed a valid link, please notify the administrator.

Maybe this is a forumissue, since I also notice this with another threat.

You can filter on color, but I don't believe you can sum on a color.

Probably it can be done with VBA, but that is not my expertice.


If you can add why the cells are collered, we can use that argument in a formula.