Thread: Sum Italics
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mathew P Bennett Mathew P Bennett is offline
external usenet poster
 
Posts: 49
Default 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