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?
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?
http://www.cpearson.com/excel/colors.htm
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"apw3b" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
See
http://cpearson.com/excel/colors.htm
In article <[email protected]>,
"apw3b" <[email protected]> wrote:
> 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?
Try:
=SUMPRODUCT(--(FontColor(F3:F6)=3);F3:F6)
With:
Public Function FontColor(myCell As Range) As Variant
Application.Volatile True
FontColor = myCell.Font.ColorIndex
End Function
Ola Sandstrom
You may want to take away Volatile (' Application.Volatile True)
and use something like this instead =FontColor(A1)+Now()*0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks