PDA

View Full Version : How to add cells with Conditional Formatting



leovilla64
04-19-2017, 01:24 PM
Hello friends, I need some help
In the spreadsheet the values of column D have conditional formatting, so the values in red refer to D and black refers to C
I would like to add the values in red and black
Is there any way to do this?

Leandro

mdmackillop
04-19-2017, 01:37 PM
=SUMIF(C:C,"C",D: D) and =SUMIF(C:C,"D",D: D)