SumIf function in Excel

A

apw3b

How do I obtain the sum of cell range that uses the font color as the 'if'
criteria?
I have tried the following; =SUMIF(F3:F6,"Font.ColorIndex = 3") but this
does not work.
Has anyone a solution?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
SUMIF with criteria "<>" & "=" 4
sumif issues 1
Multiple Columns in Sum Range using SUMIFS 1
Sumif apllying to all sheets in workbook 2
SumIf equation question 6
Have the SUMIF result (formula) on a separate sheet/tab 2
Sum data using sumif 3

Top