I am trying to write a function that will sum up costs in two different categories. If the month (which is always in the same cells C2:AG2) is red (font color), then it should be summing in a cell that is counting projected cost. if the font color is black, then is should be summing the numbers in a cell that is year to date costs
Function projtotal(costs As Range, color as string) As Long
'sum the costs of the months in red = projected cost
'sum the costs of the months in black = year to date costs
End Function
any ideas?
Function projtotal(costs As Range, color as string) As Long
'sum the costs of the months in red = projected cost
'sum the costs of the months in black = year to date costs
End Function
any ideas?
