Excel.png

Hi Guys,

thanks to google i have been able to work out formulas from scratch but im stuck on this one, tried multiple formulas with no luck.

what i'm trying to do is -

enter or select an area / Joinery Name in column B which is conditionally formatted

enter different data in column E to N to get a total $ in column O

the above is working beautifully, now my problem is i want all the values in column O to be summed up in column P where it is formatted so where the Kitchen at the top is would have an amount of $1530.00. but only sum the values between the formatting cells.

any help would be much appreciated.