Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If cell is Bold then 1, if cell is Italics then 2? | Excel Discussion (Misc queries) | |||
can a function return part of it's result in italics? | Excel Worksheet Functions | |||
Summings cells in Italics | Excel Discussion (Misc queries) | |||
Stuck in Italics | Excel Discussion (Misc queries) | |||
bold italics or underline | Excel Discussion (Misc queries) |