View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SRN SRN is offline
external usenet poster
 
Posts: 6
Default SUM of column based on format criteria

I need to sum a column which has a series of dollar amounts, some the same,
but only include numbers once they have been made bold. eg

23.50
67.80 (Bold format)
99.45
88.23
23.50(Bold format)
22.45
88.23
19.00

In the above example the sum would be only of numbers with bold format. What
would e the formula to do that

Thanks

SRN