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
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
=SUMIF(C:C,"C",D: D) and =SUMIF(C:C,"D",D: D)
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'