Hi,
I want to apply a condition (to sum up a column of numbers, for example) based on character format (for example, whether the numbers are bold or not).
Which condition shall I use? (font.fontstyle= "bold"?). It does not work!
The function to be used is :
SOMMA.SE (in Italian) with the following parameters:
Range on which the condition apply
Condition
Range to sum up.
Such a function works perfectly well if I use a condition based, for example, on the value (for example, ">10000"). And if the condition is a cell format?
Bruno
I want to apply a condition (to sum up a column of numbers, for example) based on character format (for example, whether the numbers are bold or not).
Which condition shall I use? (font.fontstyle= "bold"?). It does not work!
The function to be used is :
SOMMA.SE (in Italian) with the following parameters:
Range on which the condition apply
Condition
Range to sum up.
Such a function works perfectly well if I use a condition based, for example, on the value (for example, ">10000"). And if the condition is a cell format?
Bruno