View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zakynthos Zakynthos is offline
external usenet poster
 
Posts: 115
Default Adding by font colour in Excel

Mike,

Many thanks

Tony

"Mike H" wrote:

Have a look he-

http://www.xldynamic.com/source/xld....r.html#summing

Mike

"Zakynthos" wrote:

I have a spreadsheet with values formatted in one column in red and some in
black.

What function or formula can I use to count only the numbers in red?

many thanks