Sum Italics
Good Evening All,
I have a ss (cash flow) where some of the values are entered as italics, and
the rest as normal.
I would like to be able to differenciate between the two when using a count
function, plus using the sum
function (but not together)
I thought of using an array, something like this, (or maybe a sumproduct)
ie SUM{(IF(A1:A10<Italics,FALSE,A1:10))}
I feel sure some VBA will be needed.
Any help or pointers would be most appreciated.
Cheers
Mathew
|