Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If cell is Bold then 1, if cell is Italics then 2? Yong Sheng Excel Discussion (Misc queries) 4 May 8th 23 07:44 PM
can a function return part of it's result in italics? Jamie Excel Worksheet Functions 1 June 2nd 08 08:46 PM
Summings cells in Italics Luke Excel Discussion (Misc queries) 3 May 23rd 07 11:03 AM
Stuck in Italics Tim Excel Discussion (Misc queries) 1 May 16th 05 12:33 AM
bold italics or underline Dorothy Excel Discussion (Misc queries) 5 February 16th 05 03:15 PM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"